On Wed, Sep 17, 2008 at 11:01 AM, M C <shimeee@xxxxxxxxx> 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?
