Seamus Abshere <seamus@xxxxxxxxxxx> writes: > On Mon, Feb 22, 2016, at 02:14 PM, Tom Lane wrote: >> IOW, almost certainly we *don't* realize that the query will involve scanning through gigabytes of index pages. But btree indexes are much simpler and easier to make that estimate for... > Isn't this the crux of my issue, at least? Not unless you are using a GIST index for booleans, which I sure hope you ain't. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general