Re: Need help in performance tuning.

From: Samuel Gendler <sgendler(at)ideasculptor(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Need help in performance tuning.
Date: 2010-07-09 04:19:22
Message-ID: AANLkTin4Q4APRnbJ85FRasU7n8LuhKibKYcGnexsEbTt@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Jul 8, 2010 at 8:11 PM, Craig Ringer
<craig(at)postnewspapers(dot)com(dot)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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-07-09 04:42:46 Re: Need help in performance tuning.
Previous Message Craig Ringer 2010-07-09 03:11:02 Re: Need help in performance tuning.