Re: TPC-R benchmarks - Mailing list pgsql-performance

From Shridhar Daithankar
Subject Re: TPC-R benchmarks
Date
Msg-id 3F784607.5020705@persistent.co.in
Whole thread Raw
In response to Re: TPC-R benchmarks  (Oleg Lebedev <oleg.lebedev@waterford.org>)
Responses Re: TPC-R benchmarks
List pgsql-performance
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.

  HTH

  Shridhar


pgsql-performance by date:

Previous
From: Oleg Lebedev
Date:
Subject: Re: TPC-R benchmarks
Next
From: Franco Bruno Borghesi
Date:
Subject: Re: Performance: BigInt vs Decimal(19,0)