| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Shaun Thomas <sthomas(at)optionshouse(dot)com> |
| Cc: | 'Reza Taheri' <rtaheri(at)vmware(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: PGSQL, checkpoints, and file system syncs |
| Date: | 2014-04-09 16:42:23 |
| Message-ID: | 20140409164223.GB8686@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Apr 8, 2014 at 02:00:05PM +0000, Shaun Thomas wrote:
> So if you are on a 1GB RAID card, set it to 1GB. Once you have 1GB
> of dirty memory (from a checkpoint or whatever), Linux will begin
> flushing.
>
> This is a pretty well-known issue on Linux systems with large amounts
> of RAM. Most VM servers fit that profile, so I'm not surprised it's
> hurting you.
Agreed. The dirty kernel defaults Linux defaults are too high for
systems with large amounts of memory. See sysclt -a | grep dirty for a
list.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2014-04-09 16:51:27 | Re: PGSQL, checkpoints, and file system syncs |
| Previous Message | Bruce Momjian | 2014-04-09 11:46:27 | Re: Why shared_buffers max is 8GB? |