On Thu, May 28, 2009 at 10:24 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > OTOH, if you've got it all sussed out, then ignore the request for more information. I don't *know* if I have it "all sussed out", but I *do* know why Postgres is doing what it is doing in this particular case. It's assuming that the value in question is evenly distributed throughout the table, when in actuality, the value in question is clustered at the very end of the table. What I don't have sussed out his how best to address this issue. The most obvious solution would be an option to tell Postgres not to assume that the value is evenly distributed throughout the table, and to take account of the fact that the data in question might very well be clustered at the very end of the table. |>ouglas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
