Speed

Speed

Posted Nov 10, 2005 19:05 UTC (Thu) by hisdad (subscriber, #5375)
Parent article: PostgreSQL 8.1 Released

Hi, I've been fiddling with dspam and pg for a little while.
My test is a body of 1390 spam. The dspam doc recommends mysql, citing performance figures that I never saw with pg.
With pg 8.0.4, on a reiserfs filesystem, learning would take 94minutes.
Recently I tried changing the filesystem to XFS. The time dropped to 52minutes.
This is certainly to do with the fdatasync() operation.
Yesterday I upgraded to 8.1 The time has dropped to 6 minutes.
Its simply amazing.
--John

---

(Log in to post comments)