Skip site navigation (1) Skip section navigation (2)

Re: Recommended number of connections

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "M C" <shimeee(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Recommended number of connections
Date: 2008-09-17 17:39:37
Message-ID: dcc563d10809171039l5d5b9ca4l975462426b8c616e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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?

In response to

pgsql-admin by date

Next:From: Kenneth MarshallDate: 2008-09-17 18:31:55
Subject: Re: Heavy postgres process
Previous:From: Tomeh, HusamDate: 2008-09-17 17:30:53
Subject: Re: Recommended number of connections

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group