Steve Lane <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
