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

From Scott Marlowe
Subject Re: [HACKERS] Slow count(*) again...
Date
Msg-id AANLkTi=s7yBPnZEbO6GAk_tUeRH_bZL=fi3NsfKxPKFf@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Slow count(*) again...  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance
On Thu, Feb 3, 2011 at 7:05 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> If you want to randomly pick 10,000 rows out of all the rows that are
> going to be inserted in the table without knowing in advance how many
> there will be, how do you do that?

Maybe you could instead just have it use some % of the rows going by?
Just a guess.

pgsql-performance by date:

Previous
From: Jeff Davis
Date:
Subject: Re: [HACKERS] Slow count(*) again...
Next
From: Andy Colson
Date:
Subject: Re: getting the most of out multi-core systems for repeated complex SELECT statements