Re: question on TRUNCATE vs VACUUM FULL - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: question on TRUNCATE vs VACUUM FULL
Date
Msg-id 20080319133733.GA6845@alvh.no-ip.org
Whole thread Raw
In response to Re: question on TRUNCATE vs VACUUM FULL  ("Mark Steben" <msteben@autorevenue.com>)
List 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 by date:

Previous
From: Bill Moran
Date:
Subject: Re: question on TRUNCATE vs VACUUM FULL
Next
From: Gregory Youngblood
Date:
Subject: Re: What is the best way to storage music files in Postgresql