Horton

Re: Slow vacuum performance

Dennis Björklund <db@zigo.dhs.org>

View thread
From: Dennis Bjorklund <db@zigo.dhs.org>
To: Patrick Hatcher <PHatcher@macys.com>
Cc: pgsql-performance@postgresql.org
Date: 2004-06-18T04:30:12Z
Lists: 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