Re: RAM usage per connection - Mailing list pgsql-admin

From Tom Lane
Subject Re: RAM usage per connection
Date
Msg-id 28150.1084392817@sss.pgh.pa.us
Whole thread Raw
In response to RAM usage per connection  (Steve Lane <slane@moyergroup.com>)
Responses Re: RAM usage per connection  (Steve Lane <slane@moyergroup.com>)
List pgsql-admin
Steve Lane <slane@moyergroup.com> writes:
> I have a customer with an application in production (postgres + php +
> apache) where we began seeing a  number of scary messages in the logs. (It's
> postgres 7.2.1, by the way).
  ^^^^^^^^^^^^^^

Reading the CVS logs for post-7.2.1 bug fixes will curl your toes.
You're irresponsible to still be running production data on that
version.  Move up to 7.2.4 before you find out the hard way.

> I tried increasing max_clients, but got a message to the effect that SHMMIN
> was set incorrectly on my machine ...

I'd expect SHMMAX to be the issue not SHMMIN.  It's set very
conservatively on many platforms, and you should not be afraid to raise
it.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems dumping database from 7.3.1
Next
From: "Gordon Ross"
Date:
Subject: Re: Problems dumping database from 7.3.1