> [I just skimmed this thread - did you increase the number of WAL logs to
> something very large, like 128?]
Yes, I tried even more.
I will be writing data quite constantly in the real scenario
later. So I wonder if increasing WAL logs will have a
positive effect or not: AFAIK when I increase it, the
duration after the max is hit will be longer then (which is
not acceptable in my case).
Could anyone confirm if I got it right?
In response to
pgsql-performance by date
|Next:||From: Greg Stark||Date: 2010-01-19 14:52:25|
|Subject: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)|
|Previous:||From: Willy-Bas Loos||Date: 2010-01-19 12:59:41|
|Subject: renice on an I/O bound box|