Re: Slow vacuum performance

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Patrick Hatcher <PHatcher(at)macys(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow vacuum performance
Date: 2004-06-18 04:30:12
Message-ID: Pine.LNX.4.44.0406180629120.8193-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew McMillan 2004-06-18 08:15:44 Re: Slow vacuum performance
Previous Message Patrick Hatcher 2004-06-17 20:09:47 Slow vacuum performance