Re: Postgres + Xapian (was Re: fulltext searching via a

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Eric Ridge <ebr(at)tcdi(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Postgres + Xapian (was Re: fulltext searching via a
Date: 2004-01-09 13:31:50
Message-ID: 1073655109.3143.18.camel@fuji.krosing.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Eric Ridge kirjutas R, 09.01.2004 kell 01:16:

> Forgetting about composite indexes for a moment, is postgres even
> capable of doing 2 index scans in this situation? Does it know how do
> take the intersection of two scans?

Not currently, but it has been in TODO for quite some time:

* Use bitmaps to fetch heap pages in sequential order [performance]
* Use bitmaps to combine existing indexes [performance]

---------------
Hannu

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Dunstan 2004-01-09 13:38:22 Re: psql \d option list overloaded
Previous Message Alvaro Herrera 2004-01-09 12:25:24 Re: Using indices with long unique IDs.

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-01-09 13:38:22 Re: psql \d option list overloaded
Previous Message ohp 2004-01-09 12:54:22 Strand COPY from problem