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.
Wow.
Some disclaimers.
1) I'm brain dead with PostgreSQL.
2) I've set it up and deployed only about 4 systems with it.
3) I compiled mine from 9.0.4 "stock" sources, and installed it stone
cold stock. I don't know anything about PostgreSQL (see #1), so I didn't
touch *ANY* tuning values in the configuration.
Same VM as before that broke MySQL's back.
18577 msgs (560MB) imported in:
real 65m7.098s
user 2m27.978s
sys 0m16.982s
$ ~/searchtest
Searching INBOX #msgs = 18577
[Updating Index] Time=1.418382 (COLD search)
[NOFIND] Time=0.489393, matches=18577
[date] Time=0.315028, matches=18577
[here] Time=0.323558, matches=18577
The import was about 3 *TIMES* faster.
OK, I'm always suspicious when I see differences as large as these.
Maybe I need to upgrade my MySQL or recompile it with targeted tunings?
I'll try MySQL 5.5 next.
This new result changes things a bit.
=R=
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
