Re: Question about indexes - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Question about indexes
Date
Msg-id 87vfmwrtxt.fsf@stark.xeocode.com
Whole thread Raw
In response to Question about indexes  (Greg Stark <gsstark@mit.edu>)
Responses Re: Question about indexes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Question about indexes  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> In any case, this discussion is predicated on the assumption that the
> operations involving the bitmap are a significant fraction of the total
> time, which I think is quite uncertain.  Until we build it and profile
> it, we won't know that.

The other thought I had was that it would be difficult to tell when to follow
this path. Since the main case where it wins is when the individual indexes
aren't very selective but the combination is very selective, and we don't have
inter-column correlation statistics ...

-- 
greg



pgsql-hackers by date:

Previous
From: "Johannes Barop"
Date:
Subject: Call a function when a User (dis)connects from the Server/Database
Next
From: Tom Lane
Date:
Subject: Re: Function call