Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows
Дата
Msg-id AANLkTikKmWDWNxzmFNGa_b7e+HXN5bh-Z1-PVxxeNs9x@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows  (Alexandre de Arruda Paes <adaldeia@gmail.com>)
Ответы Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows  (Dimitri <dimitrik.fr@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
On Sat, Aug 21, 2010 at 9:49 AM, Alexandre de Arruda Paes
<adaldeia@gmail.com> wrote:
> Only for discussion: the CLUSTER command, in my little knowledge, is a
> intrusive command that's cannot recover the dead tuples too.
>
> Only TRUNCATE can do this job, but obviously is not applicable all the time.

Either VACUUM or CLUSTER will recover *dead* tuples.  What you can't
recover are tuples that are still visible to some running transaction.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

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

Предыдущее
От: Alexandre de Arruda Paes
Дата:
Сообщение: Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows
Следующее
От: Dimitri
Дата:
Сообщение: Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows