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.
In response to
pgsql-performance by date
|Next:||From: J. Andrew Rogers||Date: 2005-07-29 19:21:53|
|Subject: Re: Performance problems on 4/8way Opteron (dualcore)|
|Previous:||From: Luke Lonergan||Date: 2005-07-29 19:02:30|
|Subject: Re: Performance problems testing with Spamassassin|