Home > mailing lists

When to vacuum a table? - Mailing list pgsql-performance

From	Joost Kraaijeveld
Subject	When to vacuum a table?
Date	November 26, 2006 10:24:29
Msg-id	1164540257.7902.0.camel@panoramix Whole thread Raw
Responses	Re: When to vacuum a table? Re: When to vacuum a table? Re: When to vacuum a table?
List	pgsql-performance

Tree view

Hi,

Are there guidelines (or any empirical data) available how to determine
how often a table should be vacuumed for optimum performance or is this
an experience / trial-and-error thing?

TIA

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

pgsql-performance by date:

From: andrew@pillette.com
Date: 26 November 2006, 00:26:38
Subject: Re: Massive delete of rows, how to proceed?

From: "Marcelo Costa"
Date: 26 November 2006, 11:43:20
Subject: Re: When to vacuum a table?

When to vacuum a table? - Mailing list pgsql-performance

Previous

Next