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 по дате отправления:

Предыдущее
От: Chris Bitmead
Дата:
Сообщение: Re: PostgreSQL & the BSD License
Следующее
От: Chris Bitmead
Дата:
Сообщение: Re: PostgreSQL & the BSD License