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
So, what are ya doing and how many users are you supporting at once?
In response to
pgsql-admin by date
|Next:||From: Kenneth Marshall||Date: 2008-09-17 18:31:55|
|Subject: Re: Heavy postgres process|
|Previous:||From: Tomeh, Husam||Date: 2008-09-17 17:30:53|
|Subject: Re: Recommended number of connections|