Re: Performance problems testing with Spamassassin

From: Matthew Schumacher <matt(dot)s(at)aptalaska(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance problems testing with Spamassassin
Date: 2005-07-29 19:16:52
Message-ID: 42EA80A4.7070705@aptalaska.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ok,

Here is something new, when I take my data.sql file and add a begin and
commit at the top and bottom, the benchmark is a LOT slower?

My understanding is that it should be much faster because fsync isn't
called until the commit instead of on every sql command.

I must be missing something here.

schu

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message J. Andrew Rogers 2005-07-29 19:21:53 Re: Performance problems on 4/8way Opteron (dualcore)
Previous Message Luke Lonergan 2005-07-29 19:02:30 Re: Performance problems testing with Spamassassin