Re: performance tuning: shared_buffers, sort_mem; swap - Mailing list pgsql-admin

From Tom Lane
Subject Re: performance tuning: shared_buffers, sort_mem; swap
Date
Msg-id 27214.1029257785@sss.pgh.pa.us
Whole thread Raw
In response to Re: performance tuning: shared_buffers, sort_mem; swap  (Thomas O'Connell <tfo@monsterlabs.com>)
List pgsql-admin
"Thomas O'Connell" <tfo@monsterlabs.com> writes:
> we've had the issue before where postgres will die under heavy load
> (meaning Apache is logging several requests per minute and stressing
> postgres, too) with the error about how probably we don't have shared
> memory configured appropriately.

Uh, which error exactly?  AFAIK all the shared-memory-related messages
would only come out at postmaster startup, not during peak load.  The
system is designed to ensure that those resources are all reserved
during postmaster start.

            regards, tom lane

pgsql-admin by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Leftover processes on shutdown - Debian+JDBC
Next
From: Andrew Sullivan
Date:
Subject: Re: performance tuning: shared_buffers, sort_mem; swap