Postgres Pro
Downloads
Home   >   mailing lists

Re: Why does query planner choose slower BitmapAnd ? - Mailing list pgsql-general

From Seamus Abshere
Subject Re: Why does query planner choose slower BitmapAnd ?
Date
Msg-id 1456161492.1004686.528442746.62DB641D@webmail.messagingengine.com
Whole thread Raw
In response to Re: Why does query planner choose slower BitmapAnd ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Why does query planner choose slower BitmapAnd ?
List pgsql-general
Tree view 
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
btreeindexes are much simpler and easier to make that estimate for... 

Isn't this the crux of my issue, at least?


--
Seamus Abshere, SCEA
+598 99 54 99 54
https://github.com/seamusabshere

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why does query planner choose slower BitmapAnd ?
Next
From: Tom Lane
Date:
Subject: Re: Why does query planner choose slower BitmapAnd ?