On Tue, Aug 09, 2011 at 12:11:48PM -0400, Tom Lane wrote: > Now part of the reason why the estimate is so bad is the sub-select, > which completely defeats selectivity estimation for the ending_tsz > condition. Could we see EXPLAIN ANALYZE for the query without a > sub-select, both with and without enable_bitmapscan? working on it. Best regards, depesz -- The best thing about modern society is how easy it is to avoid contact with it. http://depesz.com/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general