Postgres Pro
Downloads
Home   >   mailing lists

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

From Joost Kraaijeveld
Subject When to vacuum a table?
Date
Msg-id 1164540257.7902.0.camel@panoramix
Whole thread Raw
Responses Re: When to vacuum a table?  ("Marcelo Costa" <marcelojscosta@gmail.com>)
Re: When to vacuum a table?  ("Jim C. Nasby" <jim@nasby.net>)
Re: When to vacuum a table?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
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:

Previous
From: andrew@pillette.com
Date:
Subject: Re: Massive delete of rows, how to proceed?
Next
From: "Marcelo Costa"
Date:
Subject: Re: When to vacuum a table?