On Thu, Feb 3, 2011 at 6: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?Reservoir sampling, as the most well-known option: http://en.wikipedia.org/wiki/Reservoir_sampling-- - David T. Wilsondavid.t.wilson@gmail.com
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?
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных