Re: how to change the index chosen in plan? - Mailing 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