On Wed, Sep 17, 2008 at 11:01 AM, M C <[EMAIL PROTECTED]> 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? -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
