Tom Lane writes:
Please provide a self-contained test case for this. In testing here, 8.4 can still figure out that it ought to use an indexscan against the large table ... so there is some aspect of your tables that you're not showing us.
It is possible, and very likely, that it is an issue with the distribution of values.
The data is 40GB+ and the largest table is 200M+ rows.. Setting a standalone setup may be difficult, but what we could do is something like webex where you, or someone else we would trust, would connect to a web conference and tell us what to type.
-- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
