Neat. That was my 'you learn something every day' moment. Thanks. On Thu, Feb 3, 2011 at 9:06 PM, David Wilson <david.t.wil...@gmail.com>wrote:
> > > On Thu, Feb 3, 2011 at 6:05 PM, Robert Haas <robertmh...@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? >> > > Reservoir sampling, as the most well-known option: > http://en.wikipedia.org/wiki/Reservoir_sampling > > -- > - David T. Wilson > david.t.wil...@gmail.com >
