Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group