From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
---|---|
To: | "Marinos Yannikos" <mjy(at)geizhals(dot)at> |
Cc: | "pgsql-performance" <pgsql-performance(at)postgresql(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: 8.3.9 - latency spikes with Linux (and tuning for consistently low latency) |
Date: | 2010-04-15 17:47:26 |
Message-ID: | 4BC70ADE0200002500030965@gw.wicourts.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Have you checked whether the spikes correlate with checkpoints?
> Turn on log_checkpoints and watch for awhile. If so, fooling with
> the checkpoint parameters might give some relief.
If that by itself doesn't do it, I've found that making the
background writer more aggressive can help. We've had good luck
with:
bgwriter_lru_maxpages = 1000
bgwriter_lru_multiplier = 4.0
If you still have checkpoint-related latency issues, you could try
scaling back shared_buffers, letting the OS cache handle more of the
data.
Also, if you have a RAID controller with a battery-backed RAM cache,
make sure it is configured for write-back.
-Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Crooke | 2010-04-15 19:42:51 | HELP: How to tame the 8.3.x JDBC driver with a biq guery result set |
Previous Message | Tom Lane | 2010-04-15 17:38:00 | Re: 8.3.9 - latency spikes with Linux (and tuning for consistently low latency) |