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