Guoping Zhang wrote:
> a) The tests consists of ten thousands very small transactions, which are
> not grouped, that is why so slow with compare to set fsync off.
If those transactions are submitted by concurrent applications over
several simulataneous connections, playing with commit_delay and
commit_siblins may improve your situation.
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
In response to
pgsql-performance by date
|Next:||From: Andrus||Date: 2006-04-28 09:00:35|
|Subject: Re: CPU usage goes to 100%, query seems to ran forever|
|Previous:||From: Mikael Carneholm||Date: 2006-04-28 08:51:22|
|Subject: Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql|