Re: Partial indices - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Partial indices
Date
Msg-id 200007070130.VAA28052@candle.pha.pa.us
Whole thread Raw
In response to Re: Partial indices  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Added to TODO:

    * Re-enable partial indexes

> Mike Mascari <mascarm@mascari.com> writes:
> >> Are Partial Indices still supported into latest release of PostgreSQL?
>
> > I think they have suffered some serious bit-rot over the years
> > and are no longer functional, although some of the core code
> > still exists in the backend.
>
> Actually, quite a LOT of partial-index support code still exists in the
> backend.  Someone removed support for the "WHERE predicate" clause of
> CREATE INDEX from the grammar, but I don't know when or why that was
> done.  AFAICT everything is still there to support the feature
> downstream, and it doesn't look particularly bit-rotted.
>
> Someday when we don't have any more-pressing problems, I'd like to try
> to re-enable that support.  At the very least I might learn why it
> was disabled ;-)
>
> (Hey Bruce, do we have a TODO item for "Fix partial indices"?)
>
>             regards, tom lane
>


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: PostgreSQL & the BSD License
Next
From: Chris Bitmead
Date:
Subject: Re: PostgreSQL & the BSD License