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
Список 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 по дате отправления: