Andy,
* andy (andy(at)squeakycode(dot)net) wrote:
> My website is about to get a little more popular. I'm trying to add
> in some measurements to determine an upper limit of how many
> concurrent database connections I'm currently using.
PG is really *much* happier if you have only one backend per CPU in your
system. The way to get there is by using a connection pooler like
pg_bouncer and configuring it based on how many CPUs you have.
pg_bouncer can also provide stats for you.
Thanks,
Stephen