Re: disabling an index without deleting it?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: disabling an index without deleting it?
Дата
Msg-id 6515.1204142566@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: disabling an index without deleting it?  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-performance
Jeff Davis <pgsql@j-davis.com> writes:
>>> begin;
>>> drop index abc_dx;
>>> select ....
>>> rollback;

> It may cause catalog bloat though, right?

Not in this particular case; AFAIR this will only result in catalog row
deletions, not updates.  So when the deletions roll back, there's no
dead rows to clean up.

            regards, tom lane

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