Re: serious problems with vacuuming databases

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: serious problems with vacuuming databases
Дата
Msg-id 44398162.6060004@fuzzy.cz
обсуждение исходный текст
Ответ на Re: serious problems with vacuuming databases  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: serious problems with vacuuming databases  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-performance
> Huh, I didn't suggest to dump/reload.  I suggested CLUSTER.  You need to
> apply it only to tables where you have lots of dead tuples, which IIRC
> are A, C and D.

Sorry, I should read more carefully. Will clustering a table according
to one index solve problems with all the indexes on the table (if the
table has for example two indexes?).

t.v.

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: serious problems with vacuuming databases
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: serious problems with vacuuming databases