Greg Sabino Mullane <greg(at)endpoint(dot)com> writes:
> Found a good demonstration of the problem. Here's explain analyze of a
> query on 9.2 with enable_indexonlyscan = off; This produces the exact same
> plan as 8.3. The tables in question have been analyzed. Changing
> random_page_cost has no effect. The main foobar table has 17M rows.
Can you provide a self-contained test case for this (ie, sample data)?
regards, tom lane