Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect) - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)
Date
Msg-id 379F18E5.FD8A5E0D@alumni.caltech.edu
Whole thread Raw
In response to Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > This was in postgresql code some time ago, but was removed
> > for some reason I don't remember.
> It was?  There's still a ton of code in the optimizer to support it
> (a big chunk of indxqual.c is for testing index predicates).

There was talk of removing it, but it seemed to be a Bad Idea to do
so. The discussion even provoked a negative response from the Gods
themselves (in the voice of Paul Aoki) and led to the short
description of them in the docs.

They have definitely been neglected, but are a Good Thing and should
be rehabbed...
                    - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


pgsql-hackers by date:

Previous
From: Bernard Frankpitt
Date:
Subject: Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple select)
Next
From: Tom Lane
Date:
Subject: Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)