Re: how to change the index chosen in plan? - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: how to change the index chosen in plan?
Date
Msg-id 4FD327A0020000250004825B@gw.wicourts.gov
Whole thread Raw
In response to how to change the index chosen in plan?  (Rural Hunter <ruralhunter@gmail.com>)
List pgsql-performance
"Kevin Grittner"  wrote:

>> shared_buffers | 60GB
>
> You might want to compare your performance with this setting against
> a smaller setting. Many benchmarks have shown settings about a
> certain point (like 8MB to 12 MB) to be counter-productive, although
> a few have shown increased performance going past that. It really
> seems to depend on your hardware and workload, so you have to test to
> find the "sweet spot" for your environment.

Er, I meant "8GB to 12GB", not MB.  Sorry.

-Kevin

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: how to change the index chosen in plan?
Next
From: Kevin Kempter
Date:
Subject: partitioning performance question