Re: Size for vacuum_mem

From: Neil Conway <neilc(at)samurai(dot)com>
To: Francisco Reyes <lists(at)natserv(dot)com>
Cc: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Size for vacuum_mem
Date: 2002-12-05 00:38:12
Message-ID: 1039048692.379.143.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2002-12-05 00:57:16 Re: 7.3 RPMS
Previous Message Neil Conway 2002-12-05 00:36:27 Re: psql question