On Tue, Aug 30, 2011 at 1:26 AM, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
> I doubt this has anything to do with your problem, just pointing this out as
> future guidance. Until there's a breakthrough in the PostgreSQL buffer
> cache code, there really is no reason to give more than 8GB of dedicated
> memory to the database on Linux via shared_buffers. You're better off
> letting the OS do caching with it instead.
>
Any differing advice for FreeBSD? I'm running with 5GB on a 24GB RAM
server (about to be replaced with a server with 48GB RAM).