| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Melvin Davidson <melvin6925(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | Michael H <michael(at)wemoto(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: CentOS - PostgreSQL 9.2.13 -> 9.4 |
| Date: | 2015-08-18 16:29:12 |
| Message-ID: | 55D35D58.9000203@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 08/18/2015 09:19 AM, Melvin Davidson wrote:
>>8 x 16GB 1600MHz PC3-12800 DDR3 - 128GB total
> >>shared_buffers=60GB
>
> I would say 60GB is too high when you have 128GB system memory.
> Try lowering it to shared_buffers=32GB and let the O/S handle more of
> the work.
I would also look at see if you are checkpointing either via segment
rollover or time.
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2015-08-18 16:39:09 | Re: CentOS - PostgreSQL 9.2.13 -> 9.4 |
| Previous Message | Melvin Davidson | 2015-08-18 16:19:07 | Re: CentOS - PostgreSQL 9.2.13 -> 9.4 |