Re: Creating Empty Index

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Creating Empty Index
Дата
Msg-id CAB7nPqQpV1km2tU03ZyQzWiEVzmo3UQnEbC0-PcjE0_uJefoEg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Creating Empty Index  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: Creating Empty Index  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Sat, Nov 2, 2013 at 10:28 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
> What exactly would be the point? Indexes are automatically maintained by
> postgres. Something that isn't doesn't seem to me to qualify for the
> description of "index".
Perhaps an index without data that could be used by the planner for
automatic query tuning to evaluate how a query could run if the index
exists? Like the concept of hypothetical indexes or something like the
possibility to do a CREATE/ALTER INDEX ... WITH [ NO ] DATA.
-- 
Michael



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Creating Empty Index
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: [GENERAL] Cannot create matview when referencing another not-populated-yet matview in subquery