Re: When do vacuumed pages/tuples become available for reuse?

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: When do vacuumed pages/tuples become available for reuse?
Дата
Msg-id CAHOFxGph35T4z-gHTksNiK=hLBUvr0dF_B_PDpVA9-bnyYfs2g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: When do vacuumed pages/tuples become available for reuse?  (rihad <rihad@mail.ru>)
Ответы Re: When do vacuumed pages/tuples become available for reuse?  (Michael Paquier <michael@paquier.xyz>)
Re: When do vacuumed pages/tuples become available for reuse?  (rihad <rihad@mail.ru>)
Список pgsql-general
Дерево обсуждения
Way to many indexes. I'm going to have a hard time convincing our programmers to get rid of any of them )

You can create (concurrently) an identical index with a new name, then drop old version concurrently and repeat for each. It doesn't help you figure out the root cause and how to prevent it from happening again, but gets you to a fresh start at least.

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: When do vacuumed pages/tuples become available for reuse?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: When do vacuumed pages/tuples become available for reuse?