On Thu, Nov 11, 2010 at 10:26 PM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote: > Hello > > look on EXPLAIN ANALYZE command. Probably your statistic are out, and > then planner can be confused. EXPLAIN ANALYZE statement show it. As I noted earlier, I did set statistics to 1000 an re-ran vacuum analyze and the plan did not change. What other diagnostics can I provide? This still doesn't answer the 40000 row question, though. It seems absurd to me that the planner would give up and just use 40000 rows (0.02 percent of the actual result). -- Jon -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
