Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Zeugswetter Andreas IZ5 <Andreas(dot)Zeugswetter(at)telecom(dot)at>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)
Date: 1999-07-28 14:51:17
Message-ID: 379F18E5.FD8A5E0D@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)alumni(dot)caltech(dot)edu
South Pasadena, California

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-07-28 14:57:00 Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple se lect)
Previous Message Thomas Lockhart 1999-07-28 14:34:56 Re: [PORTS] RedHat6.0 & Alpha