Horton

Re: [HACKERS] Slow count(*) again...

Jeremy Harris <jgh@wizmail.org>

View thread
From: Jeremy Harris <jgh@wizmail.org>
To: pgsql-performance@postgresql.org
Date: 2011-02-04T00:29:22Z
Lists: pgsql-hackers, pgsql-performance 
On 2011-02-03 23:29, Robert Haas wrote:
> Yeah, but you'll be passing the entire table through this separate
> process that may only need to see 1% of it or less on a large table.

It doesn't sound too impossible to pass only a percentage, starting high
and dropping towards 1% once the loaded size has become "large".
-- 
Jeremy