Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Re: bitmap indexes - performance
On Thu, Jul 1, 2010 at 11:21 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote: > In particular, I recall some discussions about developing a "streaming > API" whereby an index AM could return a bitmap page-by-page or so, > rather than having to construct the whole thing in-memory before > anything could happen. This would be a huge win for AND/OR cases, > and even for a simple indexscan it would eliminate the existing startup > cost penalty for a bitmap scan. Streaming like this would also > eliminate the problem of having to lossify large bitmaps in order to > not overrun memory. Now that would be cool. The existing startup penalty for a bitmap scan is the pits. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company
In response to
- Re: bitmap indexes - performance at 2010-07-01 15:21:26 from Tom Lane
pgsql-hackers by date
Next: From: Robert Haas Date: 2010-07-01 15:54:44 Subject: Re: Cannot cancel the change of a tablespace Previous: From: Tom Lane Date: 2010-07-01 15:21:26 Subject: Re: bitmap indexes - performance