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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
