| From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
|---|---|
| To: | Johnny Tan <johnnydtan(at)gmail(dot)com> |
| Cc: | "ac(at)hsk(dot)hk" <ac(at)hsk(dot)hk>, Josh Krupka <jkrupka(at)gmail(dot)com>, Alex Kahn <alex(at)paperlesspost(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: postgresql.conf recommendations |
| Date: | 2013-02-06 21:12:50 |
| Message-ID: | 1360185170.99635.YahooMailNeo@web162903.mail.bf1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Johnny Tan <johnnydtan(at)gmail(dot)com> wrote:
> Wouldn't this be controlled by our checkpoint settings, though?
Spread checkpoints made the issue less severe, but on servers with
a lot of RAM I've had to make the above changes (or even go lower
with shared_buffers) to prevent a burst of writes from overwhelming
the RAID controllers battery-backed cache. There may be other
things which could cause these symptoms, so I'm not certain that
this will help; but I have seen this as the cause and seen the
suggested changes help.
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Strahinja Kustudić | 2013-02-07 12:06:53 | Re: postgresql.conf recommendations |
| Previous Message | Josh Krupka | 2013-02-06 20:27:46 | Re: postgresql.conf recommendations |