Re: Is vacuum full lock like old's vacuum's lock? - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Is vacuum full lock like old's vacuum's lock?
Date
Msg-id 20020302012138.J7348-100000@zoraida.natserv.net
Whole thread Raw
In response to Is vacuum full lock like old's vacuum's lock?  (Francisco Reyes <lists@natserv.com>)
Responses Re: Is vacuum full lock like old's vacuum's lock?
List pgsql-general
On 1 Mar 2002, Neil Conway wrote:

> Why do you need 'vacuum full' rather than just 'vacuum'? Read the docs,
> it's usually not necessary.

Because every night I delete/reload a big chunk of my data and then once a
week I delete/reload the entire dataset... about 7 million records.

I don't truncate because I want the users to see a "Stable" view of the
system at any point so I have the delete/reload inside of a commit
statement.


pgsql-general by date:

Previous
From: "Thomas T. Thai"
Date:
Subject: UPDATE with value from another table
Next
From: Oliver Elphick
Date:
Subject: Re: UPDATE with value from another table