Re: Slow vacuum performance - Mailing list pgsql-performance

From Dennis Bjorklund
Subject Re: Slow vacuum performance
Date
Msg-id Pine.LNX.4.44.0406180629120.8193-100000@zigo.dhs.org
Whole thread Raw
In response to Slow vacuum performance  (Patrick Hatcher <PHatcher@macys.com>)
List pgsql-performance
On Thu, 17 Jun 2004, Patrick Hatcher wrote:

> I have 6 million row table that I vacuum full analyze each night.  The time
> seems to be streching out further and further as I add more rows.  I read

You could try to run normal (non full) vacuum every hour or so. If you do
normal vacuum often enough you probably don't need to run vacuum full at
all.

--
/Dennis Björklund


pgsql-performance by date:

Previous
From: Patrick Hatcher
Date:
Subject: Slow vacuum performance
Next
From: Andrew McMillan
Date:
Subject: Re: Slow vacuum performance