| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | <ruralhunter(at)gmail(dot)com>, "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | <pgsql-performance(at)postgresql(dot)org>,<tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: how to change the index chosen in plan? |
| Date: | 2012-06-09 15:38:24 |
| Message-ID: | 4FD327A0020000250004825B@gw.wicourts.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Kempter | 2012-06-09 17:58:44 | partitioning performance question |
| Previous Message | Kevin Grittner | 2012-06-09 14:39:06 | Re: how to change the index chosen in plan? |