Re: vacuum/reindex

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: vacuum/reindex
Дата
Msg-id c7136ebf-465f-b2c0-d6a5-ee23949a235b@gmail.com
обсуждение исходный текст
Ответ на Re: vacuum/reindex  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
On 6/14/19 2:13 PM, Ron wrote:
> On 6/14/19 2:55 PM, Rob Sargent wrote:
>> Is reindex table redundant after vacuum(analyse,verbose)?
>
> Instead of "redundant", I'd call it "backwards", since doing a 
> vacuum(analyse,verbose) on a freshly reindexed table seems more fruitful.
>
Does reindex remove (dead) row versions as vacuum does (in the 
indices)?  Maybe I don't need reindex at all as I do NOT suspect any 
corruption - was just rebuilding after having removed 15M data rows in 
vacuum





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

Предыдущее
От: Ron
Дата:
Сообщение: Re: vacuum/reindex
Следующее
От: Leandro Guimarães
Дата:
Сообщение: Copy Bulk Ignore Duplicated