Re: Large shared_buffer stalls WAS: proposal: Set effective_cache_size to greater of .conf value, shared_buffers

On 09/13/2013 09:27 AM, Merlin Moncure wrote:
> I happen to be one of those "couple" people.  Load goes from 0.1 to
> 500 without warning then back to 0.1 equally without warning.
> Unfortunately the server is in a different jurisdiction such that it
> makes deep forensic analysis impossible.  I think this is happening
> more and more often as postgres is becoming increasingly deployed on
> high(er) -end servers.  I've personally (alone) dealt with 4-5
> confirmed cases and there have been many more.  We have a problem.

Can you explain a bit more about this?  I'm currently grappling with a
db cluster which has periodic mysterious total LWLock paralysis, and is
configured with 8GB shared_buffers (and 512GB ram installed).

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com