On 8/15/2011 5:03 AM, Paul J Stevens wrote:
On 08/15/2011 12:16 PM, Robin Horforth wrote:
I'll try PostgreSQL 9.0.x next. My preliminary tests show it to be
much faster on these sorts of operations.
Very interesting! Keep us posted.
Interesting.
When I run a duplicate import pass (adding the same emails to the INBOX,
hence, doubling the size of the mailbox), I see a worrying performance
reduction.
(Same VM setup, PostgreSQL 9.0.4 with stock configuration):
18577 mesgs imported to INBOX:
real 131m17.473s
user 2m15.263s
sys 0m30.752s
(This is about twice as long as the first 18577 messages)
$ ~/searchtest
Searching INBOX #msgs = 37154
[Updating Index] Time=1.734378 (cold search)
[NOFIND] Time=0.811997, matches=37154
[date] Time=0.677009, matches=37154
[here] Time=0.683351, matches=37154
This still makes MySQL 5.1 look very poor indeed.
=R=
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
