Postgres Pro
Downloads
Home   >   mailing lists

Re: Shortening time of vacuum analyze - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Shortening time of vacuum analyze
Date
Msg-id 20020130154714.J20009@mail.libertyrms.com
Whole thread Raw
In response to Re: Shortening time of vacuum analyze  (Francisco Reyes <lists@natserv.com>)
Responses Re: Shortening time of vacuum analyze  (Francisco Reyes <lists@natserv.com>)
List pgsql-general
Tree view 
On Wed, Jan 30, 2002 at 12:23:50PM -0500, Francisco Reyes wrote:

> You can put the delete/load inside a transaction so the users will never
> see an empty table. Truncate can not be placed inside a transaction.

True enough.  But why not leave the table unvacuumed, then, until a
more convenient time?  You are, of course, paying a cost in
performance during that time, but not as great as you would with
vacuum.

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110

pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: please help me build a business case for using postgresql at my company
Next
From: "Bjoern Metzdorf"
Date:
Subject: Re: process exited with status 11 after XLogFlush: request is not satisfied