|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
From: Michael Tokarev (mjt_at_tls.msk.ru)
Date: Sun Sep 29 2002 - 18:03:27 CDT
Michael Tokarev wrote:
[]
> Wirehub! spamlist-extended.txt, 2021461 bytes.
>
> Create:
> type real user sys size
> hash 5.601s 5.340s 0.070s 5263360
> btree 0.957s 0.680s 0.060s 3424256
> cdb 0.156s 0.100s 0.060s 3504039
>
> Query (method described by Victor):
> type real user sys
> hash 7.335s 4.570s 2.650s
> btree 0.962s 0.920s 0.030s
> cdb 0.120s 0.110s 0.010s
And, on a much slower machine, this is P133 with 128Mb
memory and 18Mb/s SCSI disc, db 3.1.17, postfix-1.1.11.20020719:
c r e a t e q u e r y
type real user sys real user sys
hash 61.525s 58.930s 1.130s 50.689s 30.040s 19.330s
btree 19.579s 17.730s 0.830s 15.783s 13.350s 2.430s
cdb 2.564s 1.760s 0.750s 2.368s 1.920s 0.450s
/mjt
-
To unsubscribe, send mail to majordomo
postfix.org with content
(not subject): unsubscribe postfix-users
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]