Oleg Lebedev wrote:
> effective_cache_size = 32000 # typically 8KB each
That is 256MB. You can raise it to 350+MB if nothing else is running on the box.
Also if you have fast disk drives, you can reduce random page cost to 2 or 1.5.
I don't know how much this will make any difference to benchmark results but
usually this helps when queries are slow.
In response to
pgsql-performance by date
|Next:||From: Franco Bruno Borghesi||Date: 2003-09-29 14:59:27|
|Subject: Re: Performance: BigInt vs Decimal(19,0)|
|Previous:||From: Oleg Lebedev||Date: 2003-09-29 14:35:51|
|Subject: Re: TPC-R benchmarks|