Re: performance tuning: shared_buffers, sort_mem; swap

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thomas O'Connell" <tfo(at)monsterlabs(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: performance tuning: shared_buffers, sort_mem; swap
Date: 2002-08-13 16:56:25
Message-ID: 27214.1029257785@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Thomas O'Connell" <tfo(at)monsterlabs(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2002-08-13 17:03:48 Re: performance tuning: shared_buffers, sort_mem; swap
Previous Message Oliver Elphick 2002-08-13 16:56:18 Re: Leftover processes on shutdown - Debian+JDBC