Re: Help with count(*) - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: Help with count(*)
Date
Msg-id 20031114213015.GT28153@libertyrms.info
Whole thread Raw
In response to Re: Help with count(*)  (Christopher Browne <cbbrowne@acm.org>)
List pgsql-performance
On Fri, Nov 14, 2003 at 02:16:56PM -0500, Christopher Browne wrote:
> otherwise-unoccupied connection in the pool, in effect, doing a sort
> of "vacuum" of the connections.  I don't get very favorable reactions
> when I suggest that, though...

Because it's a kludge on top of another kludge, perhaps?  ;-)  This
needs to be fixed properly, not through an ungraceful series of
workarounds.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-performance by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: n_distinct way off, but following a pattern.
Next
From: George Essig
Date:
Subject: Re: INSERT extremely slow with large data sets (fwd)