Re: [HACKERS] Slow count(*) again... - Mailing list pgsql-performance

From Tom Lane
Subject Re: [HACKERS] Slow count(*) again...
Date
Msg-id 25146.1296755208@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Slow count(*) again...  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance
Robert Haas <robertmhaas@gmail.com> writes:
> I don't, however, agree with his contention that this is easy to
> implement.  It would be easy to implement something that sucked.  It
> would be hard to implement something that actually helped in the cases
> where the existing settings aren't already sufficient.

Exactly.  A hint system that actually did more good than harm would be a
very nontrivial project.  IMO such effort is better spent on making the
optimizer smarter.

            regards, tom lane

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Slow count(*) again...
Next
From: "Anne Rosset"
Date:
Subject: Re: FW: Queries becoming slow under heavy load