Re: Autovacuum is running forever

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Sachchida Ojha" <sojha(at)secure-elements(dot)com>
Cc: "Michael Glaesemann" <grzm(at)seespotcode(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum is running forever
Date: 2007-08-21 22:05:05
Message-ID: dcc563d10708211505h7907a283y7c1b88023709e3fe@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 8/21/07, Sachchida Ojha <sojha(at)secure-elements(dot)com> wrote:
> Is there any data corruption/damage to the database if we forcefully
> kill autovacuum using cron job (if it is running longer than a
> predefined time frame).

Oh, and I'd look at your I/O subsystem. You might want to look at
putting $300 hardware RAID cards with battery backed cache and 4 or so
disks in a RAID10 in them. It sounds to me like you could use more
I/O for your vacuuming. Vacuuming isn't CPU intensive, but it can be
I/O intensive.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sachchida Ojha 2007-08-21 22:07:44 Re: Autovacuum is running forever
Previous Message Scott Marlowe 2007-08-21 22:03:25 Re: Autovacuum is running forever