Re: Index ANDing & Index ORing

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Hiltibidal, Robert" <Robert(dot)Hiltibidal(at)argushealth(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Index ANDing & Index ORing
Date: 2007-02-06 09:38:47
Message-ID: 45C84CA7.2020805@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hiltibidal, Robert wrote:
> Does postgres have support for index ANDing and index ORing?

Well, 8.1+ will create an on-the-fly bitmap for x=1 AND y=2 type of queries.

What were you thinking for ORing?

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2007-02-06 09:39:36 Re: Compilation errors
Previous Message Penchalaiah P. 2007-02-06 08:41:37 Re: sql