Re: Is vacuum full lock like old's vacuum's lock?

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
Cc: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is vacuum full lock like old's vacuum's lock?
Date: 2002-03-02 06:23:59
Message-ID: 20020302012138.J7348-100000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas T. Thai 2002-03-02 06:29:20 Re: UPDATE with value from another table
Previous Message Oliver Elphick 2002-03-02 06:20:49 Re: UPDATE with value from another table