Re: Does VACUUM reorder tables on clustered indices

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Does VACUUM reorder tables on clustered indices
Дата
Msg-id 20051219132524.GA6777@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Re: Does VACUUM reorder tables on clustered indices  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Does VACUUM reorder tables on clustered indices  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Дерево обсуждения 
On Sun, Dec 18, 2005 at 10:08:22PM -0500, Tom Lane wrote:
> 
> Just for the record, that behavior is seriously broken: it violates
> MVCC if any of the deleted tuples are still visible to anyone else.

Does it remove tuples that VACUUM FULL wouldn't?  I always thought it
did essentially the same thing?

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what 
you told them to.  That actually seems sort of quaint now.    --J.D. Baldwin

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

Предыдущее
От: "Lane Van Ingen"
Дата:
Сообщение: How to Force Transactions to Process Serially on A Table
Следующее
От: Achilleus Mantzios
Дата:
Сообщение: Re: How to Force Transactions to Process Serially on A Table