Re: Partial indices

Mike Mascari <mascarm(at)mascari(dot)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