From: Scott Marlowe <scott.marlowe@gmail.com>
To: Wayne Beaver <wayne@acedsl.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Manual vacs 5x faster than autovacs?
Date: Thu, 12 Nov 2009 08:14:17 -0700
Message-ID: <dcc563d10911120714i5e24e1das20f13a0cdc348dee@mail.gmail.com> (raw)
In-Reply-To: <20091112093301.11953uc4r7pgqzy8@www.aceinnovative.com>
References: <20091112093301.11953uc4r7pgqzy8@www.aceinnovative.com>
On Thu, Nov 12, 2009 at 7:33 AM, Wayne Beaver <wayne@acedsl.com> wrote:
> Hi All,
>
> Running Pg 8.3RC2, Linux server, w/8GB RAM, OpenSuSE 10.2 OS (yes, I know
> that's old). I have seen *really* long-running autovacs eating up system
> resources. While the below is not an example of *really* long, it shows how
> I killed an autovac which had been running for more than 10 minutes, then
> ran a VAC FULL ANALYZE on same exact table in about ~2 min. Any wisdom here?
> Attributable to autovac_worker settings? Or Pg version? Other?
>
> Any insight appreciated.
Autovac running slow is (generally) a good thing. It reduces the load
on your IO subsystem so that other queries can still run fast. What
resources are your long running autovacs eating up. If top shows
500Mres and 499Mshr, then don't worry, it's not actually eating up
resources.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, wayne@acedsl.com
Subject: Re: Manual vacs 5x faster than autovacs?
In-Reply-To: <dcc563d10911120714i5e24e1das20f13a0cdc348dee@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox