| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Alan Stange <stange(at)rentec(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: difference in plan between 8.0 and 8.1? |
| Date: | 2005-08-26 15:16:08 |
| Message-ID: | 20050826151608.GA16945@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-08-26 15:16:55 | Re: difference in plan between 8.0 and 8.1? |
| Previous Message | Merlin Moncure | 2005-08-26 15:12:48 | Re: difference in plan between 8.0 and 8.1? |