Re: difference in plan between 8.0 and 8.1? - Mailing list pgsql-performance

On Fri, Aug 26, 2005 at 10:45:07AM -0400, Alan Stange wrote:
>         ->  Bitmap Heap Scan on tbltimeseries (cost=48714.09..1331000.42 rows=10854026 width=8)
>               Recheck Cond: (timeseriesid > 0)
>               ->  Bitmap Index Scan on idx_timeseris (cost=0.00..48714.09 rows=10854026 width=0)
>                     Index Cond: (timeseriesid > 0)
>
> I'm hoping someone can explain the new query plan (as I'm not sure I
> understand what it is doing).

Search for "bitmap" in the 8.1 Release Notes:

http://developer.postgresql.org/docs/postgres/release.html#RELEASE-8-1

You could probably find more detailed discussion in the pgsql-hackers
archives.

--
Michael Fuhr