Re: question on TRUNCATE vs VACUUM FULL

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: question on TRUNCATE vs VACUUM FULL
Дата
Msg-id 20080319133733.GA6845@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: question on TRUNCATE vs VACUUM FULL  ("Mark Steben" <msteben@autorevenue.com>)
Список pgsql-performance
Mark Steben escribió:

> My confusion lies in the fact that we empty table C after
> Function D finishes.  There aren't any current data or records
> To touch on the table. The MVCC leftovers are all purely dead
> Rows that should be deleted.

Not if there are open transactions that might want to look at the table
after the VACUUM FULL is completed.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: question on TRUNCATE vs VACUUM FULL
Следующее
От: Gregory Youngblood
Дата:
Сообщение: Re: What is the best way to storage music files in Postgresql