Re: Need help in performance tuning. - Mailing list pgsql-performance

From Samuel Gendler
Subject Re: Need help in performance tuning.
Date
Msg-id AANLkTin4Q4APRnbJ85FRasU7n8LuhKibKYcGnexsEbTt@mail.gmail.com
Whole thread Raw
In response to Re: Need help in performance tuning.  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: Need help in performance tuning.
List pgsql-performance
On Thu, Jul 8, 2010 at 8:11 PM, Craig Ringer
<craig@postnewspapers.com.au> wrote:
> If you're not using a connection pool, start using one.
>
> Do you really need 100 *active* working query threads at one time? Because
> if you do, you're going to need a scary-big disk subsystem and a lot of
> processors.

I see this issue and subsequent advice cross this list awfully
frequently.  Is there in architectural reason why postgres itself
cannot pool incoming connections in order to eliminate the requirement
for an external pool?

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Need help in performance tuning.
Next
From: Tom Lane
Date:
Subject: Re: Need help in performance tuning.