Re: Partial indices

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