Re: Idea how to get rid of Bitmap Heap Scan - Mailing list pgsql-performance

From Robert Haas
Subject Re: Idea how to get rid of Bitmap Heap Scan
Date
Msg-id 603c8f070912191811p75306db3jd82c5f1b891a4a64@mail.gmail.com
Whole thread Raw
In response to Re: Idea how to get rid of Bitmap Heap Scan  (Greg Stark <gsstark@mit.edu>)
Responses Re: Idea how to get rid of Bitmap Heap Scan
List pgsql-performance
On Fri, Dec 18, 2009 at 12:29 PM, Greg Stark <gsstark@mit.edu> wrote:
> A word of warning, in my experience the hardest part for changes like
> this isn't the executor changes (which in this case wouldn't be far
> from easy) but the planner changes to detect when this new plan would
> be better.

There's also the problem of making the visibility map crash-safe.  I
think I heard you might have some ideas on that one - has it been
discussed on -hackers?

...Robert

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Automatic optimization of IN clauses via INNER JOIN
Next
From: Greg Stark
Date:
Subject: Re: Idea how to get rid of Bitmap Heap Scan