Re: Vacuuming

Поиск
Список
Период
Сортировка
От Paul Lambert
Тема Re: Vacuuming
Дата
Msg-id 463FFFC5.1060909@autoledgers.com.au
обсуждение исходный текст
Ответ на Re: Vacuuming  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane wrote:
>
> I forgot to mention that any other operation that examines every table
> row will fix all the hint bits as well.  In particular a CREATE INDEX
> would do that --- so if you are planning to create some indexes then
> there's certainly no point in a VACUUM just after a table load.
>
>             regards, tom lane
>

Thanks for all the help Tom, educational as always.

--
Paul Lambert
Database Administrator
AutoLedgers

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

Предыдущее
От: "Harvey, Allan AC"
Дата:
Сообщение: 'Expensive' column in result set
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: tokenize string for tsearch?