Re: Partial indices
От | Bruce Momjian |
---|---|
Тема | Re: Partial indices |
Дата | |
Msg-id | 200007070130.VAA28052@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: Partial indices (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | 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 по дате отправления: