Re: CREATE INDEX ... ONLINE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CREATE INDEX ... ONLINE
Дата
Msg-id 5379.1155820497@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: CREATE INDEX ... ONLINE  (Greg Stark <gsstark@mit.edu>)
Список pgsql-patches
Greg Stark <gsstark@mit.edu> writes:
> Just remembered one open question I had. I'm not clear what to do with the
> index statistics. It may be that the current code is basically the right thing
> -- it leaves the statistics as they are after phase 1, ie after the regular
> index build before we go through looking for newly added tuples.

We could update them, but if there's really all that much change then
this command is going to suck pretty badly anyway :-(.

Given the current planner behavior (get actual relation length and
multiply by reltuples/relpages to estimate tuple count), the original
reltuples and relpages are probably good enough anyhow.  A big change
in index density during phase 2 seems even less likely.

            regards, tom lane

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: CREATE INDEX ... ONLINE
Следующее
От: Chris Mair
Дата:
Сообщение: Re: selecting large result sets in psql using cursors