shared_buffers on ubuntu precise

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: <sthomas(at)optionshouse(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: shared_buffers on ubuntu precise
Date: 2012-11-30 19:57:07
Message-ID: 1C168A4E-67B8-40A3-9C45-C79CA363564C@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Nov 30, 2012, at 8:06 AM, Shaun Thomas wrote:

> I say that because you mentioned you're using Ubuntu 12.04, and we were
> having some problems with PG on that platform. With shared_buffers over
> 4GB, it starts doing really weird things to the memory subsystem.
> Whatever it does causes the kernel to purge cache rather aggressively.
> We saw a 60% reduction in read IO by reducing shared_buffers to 4GB.
> Without as many reads, your writes should be much less disruptive.

Hm, this sounds like something we should look into. Before we start digging do you have more to share, or did you leave it with the "huh, that's weird; this seems to fix it" solution?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message John Lister 2012-11-30 19:59:14 Re: Comparative tps question
Previous Message Bob Jolliffe 2012-11-30 16:13:11 Re: deadlock under load