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

From Kevin Grittner
Subject Re: Need help in performance tuning.
Date
Msg-id 4C37791C0200002500033379@gw.wicourts.gov
Whole thread Raw
In response to Re: Need help in performance tuning.  (Greg Smith <greg@2ndquadrant.com>)
Responses Re: Pooling in Core WAS: Need help in performance tuning.  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Greg Smith <greg@2ndquadrant.com> wrote:

> if you're at the point where you have so many connections that you
> need a pool, the last place you want to put that is on the
> overloaded database server itself.  Therefore, it must be an
> external piece of software to be effective, rather than being part
> of the server itself.

It *is* the last place you want to put it, but putting it there can
be much better than not putting it *anywhere*, which is what we've
often seen.

-Kevin

pgsql-performance by date:

Previous
From: Jeremy Palmer
Date:
Subject: Re: Index usage with functions in where condition
Next
From: Mark Kirkwood
Date:
Subject: Re: Need help in performance tuning.