Re: Performance problems testing with Spamassassin - Mailing list pgsql-performance

From Matthew Schumacher
Subject Re: Performance problems testing with Spamassassin
Date
Msg-id 42EA80A4.7070705@aptalaska.net
Whole thread Raw
In response to Re: Performance problems testing with Spamassassin  ("Luke Lonergan" <llonergan@greenplum.com>)
List 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

pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: Performance problems testing with Spamassassin
Next
From: "J. Andrew Rogers"
Date:
Subject: Re: Performance problems on 4/8way Opteron (dualcore)