Re: Index scan and bitmap index scan - hard to understand how planner chooses

From: boraldomaster <boraldomaster(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Index scan and bitmap index scan - hard to understand how planner chooses
Date: 2013-06-24 15:26:58
Message-ID: 1372087618194-5760677.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I firstly used 9.1.
After switching to 9.2. - the problem was fixed even without index only
scan.
I added another column to my table so this wasn't index only, but still had
better index behaviour.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Index-scan-and-bitmap-index-scan-hard-to-understand-how-planner-chooses-tp5760304p5760677.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2013-06-24 15:33:39 Re: Strict mode in postgresql??
Previous Message Stuart Ford 2013-06-24 15:25:44 Re: pg_largeobject.sql script not run after upgrade