On 12/11/2013 01:44 AM, Greg Stark wrote: > On Wed, Dec 11, 2013 at 12:40 AM, Simon Riggs <si...@2ndquadrant.com> wrote: >> When we select a block we should read all rows on that block, to help >> identify the extent of clustering within the data. > So how do you interpret the results of the sample read that way that > doesn't introduce bias? > Initially/experimentally we could just compare it to our current approach :)
That is, implement *some* block sampling and then check it against what we currently have. Then figure out the bad differences. Rinse. Repeat. Cheers -- Hannu Krosing PostgreSQL Consultant Performance, Scalability and High Availability 2ndQuadrant Nordic OÜ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers