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

From: Jeremy Harris <jgh(at)wizmail(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: [HACKERS] Slow count(*) again...
Date: 2011-02-04 00:29:22
Message-ID: 4D4B4862.20203@wizmail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Shaun Thomas 2011-02-04 00:30:50 Re: [HACKERS] Slow count(*) again...
Previous Message Mladen Gogala 2011-02-04 00:13:17 Re: [HACKERS] Slow count(*) again...

Browse pgsql-performance by date

  From Date Subject
Next Message Shaun Thomas 2011-02-04 00:30:50 Re: [HACKERS] Slow count(*) again...
Previous Message Mladen Gogala 2011-02-04 00:13:17 Re: [HACKERS] Slow count(*) again...