From: Michael Fuhr <mike@fuhr.org>
To: Alan Stange <stange@rentec.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: difference in plan between 8.0 and 8.1?
Date: Fri, 26 Aug 2005 09:16:08 -0600
Message-ID: <20050826151608.GA16945@winnie.fuhr.org> (raw)
In-Reply-To: <430F2AF3.1080704@rentec.com>
References: <430F2AF3.1080704@rentec.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mike@fuhr.org, stange@rentec.com
Subject: Re: difference in plan between 8.0 and 8.1?
In-Reply-To: <20050826151608.GA16945@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox