Thursday, June 19, 2008

Re: [HACKERS] Backend Stats Enhancement Request

Decibel! <decibel@decibel.org> writes:
> Also, I don't necessarily buy that 32k * max_connections is too much
> shared memory; even with max_connections of 1000 that's only 32M,
> which is trivial for any box that's actually configured for 1000
> connections.

That's not where the problem is. The people who will be left holding
the short end of the stick are the ones who can't raise their SHMMAX
setting past a couple of megabytes.

It might be feasible to make pg_stat_activity's max string length
a postmaster-start-time configuration option.

regards, tom lane

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

No comments: