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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to