Postgres Pro
Downloads
Home   >   mailing lists

Re: Size for vacuum_mem - Mailing list pgsql-general

From Neil Conway
Subject Re: Size for vacuum_mem
Date
Msg-id 1039048692.379.143.camel@tokyo
Whole thread Raw
In response to Size for vacuum_mem  (Francisco Reyes <lists@natserv.com>)
Responses Re: Size for vacuum_mem  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
Tree view 
On Wed, 2002-12-04 at 19:17, Francisco Reyes wrote:
> What is my best bet to improve vacuum time?

If you VACUUM more frequently, each individual VACUUM takes less time.

> Currently a vacuum full takes 3+ hours and very soon the amount of data
> will increase.

Do you need to use VACUUM FULL?

Cheers,

Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: psql question
Next
From: Lamar Owen
Date:
Subject: Re: 7.3 RPMS