Re: Recommended number of connections

On Wed, Sep 17, 2008 at 11:01 AM, M C <shimeee(at)yahoo(dot)com> wrote:
> What are the "maximum" amount of "connections" allowed to "postgres"? and
> what would be a resonable amount of connection/processes to see based on
> user connections?

That really depends on what you're doing with it. If each connection
is doing a simple transaction on a small indexed set, then you can
probably have hundreds of connections open on an even modest machine.
OTOH, if you're running reports across hundreds of megs with a large
work_mem setting then you might be best with only a few dozen or so
connections.

So, what are ya doing and how many users are you supporting at once?