Re: Vacuuming on heavily changed databases

From: Bohdan Linda <bohdan(dot)linda(at)seznam(dot)cz>
To: Harald Armin Massa <haraldarminmassa(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Cc: Bohdan Linda <bohdan(dot)linda(at)seznam(dot)cz>
Subject: Re: Vacuuming on heavily changed databases
Date: 2008-05-19 15:24:11
Message-ID: 20080519152411.GA26357@bafster.baflabs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, May 19, 2008 at 04:59:42PM +0200, Harald Armin Massa wrote:
> do not vacuum DAILY. set up autovacuum to run AT LEAST every minute.
> autovacuum will flag the "deleted" rows as to be reusable by next
> insert. Make sure to use 8.3.<latest>, it's much more easy to setup
> autovacuum then before.

Hello Harald,

Thank you, will look at that. My problem is I have to use 8.0.x, but it
should be supported.

Regards,
Bohdan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Miguel Arroz 2008-05-19 17:04:41 Using "ident sameuser" with Mac OS X Leopard
Previous Message Martijn van Oosterhout 2008-05-19 15:19:07 Re: Vacuuming on heavily changed databases