Re: RAM usage per connection

Steve Lane <slane(at)moyergroup(dot)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