Re: Query planner quirk?

"Dave Menendez" <dave@sycamorehq.com> writes:
> Any comments?

Can't say much useful with such a selective report.  It'd be interesting
to see the EXPLAIN output in all four cases (small bank_id list for both
index and seq scans, ditto for large bank_id list).  Also, I don't
believe the bank_id IN () part can contribute to the index condition,
so the critical number is how many rows will match just time_id = 'P_6'
and org_allow = 1.  How many such rows are there really, and how many
does the planner estimate (use EXPLAIN with just those clauses in
WHERE)?

            regards, tom lane