From: Rosser Schwarz <rosser.schwarz@gmail.com>
To: Madison Kelly <linux@alteeve.com>
Cc: Steve Crawford <scrawford@pinpointresearch.com>
Cc: Brad Nicholson <bnichols@ca.afilias.info>
Cc: Gary Doades <gpd@gpdnet.co.uk>
Cc: pgsql-performance@postgresql.org
Subject: Re: DB is slow until DB is reloaded
Date: Mon, 4 Jan 2010 15:06:34 -0700
Message-ID: <37d451f71001041406i3f5d8d5fte8a29cfbc06998c9@mail.gmail.com> (raw)
In-Reply-To: <4B426438.40109@alteeve.com>
References: <4B423D22.7040803@alteeve.com>
<4B424215.70605@pinpointresearch.com>
<4B424FF6.40207@alteeve.com>
<4B425222.7070905@gpdnet.co.uk>
<4B425555.6020709@alteeve.com>
<1262638856.29852.4.camel@bnicholson-desktop>
<4B425E93.1050207@alteeve.com>
<4B426359.9040601@pinpointresearch.com>
<4B426438.40109@alteeve.com>
On Mon, Jan 4, 2010 at 2:57 PM, Madison Kelly <linux@alteeve.com> wrote:
> As for autovacuum, I assumed (yes, I know) that all v8.x releases enabled it
> by default. How would I confirm that it's running or not?
I believe it's not enabled by default in 8.1-land, and is as of 8.2
and later. Whether it's running or not, try "SELECT * FROM
pg_autovacuum;". If that returns the null set, it's not doing
anything, as it hasn't been told it has anything to do.
IME, however, if you really want to benefit from the autovacuum
daemon, you probably do want to be on something more recent than 8.1.
(And, yes, this is a bit of the pot calling the kettle black: I have a
mixed set of 8.1 and 8.3 hosts. Autovacuum is only running on the
latter, while the former are queued for an upgrade.)
rls
--
:wq
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: rosser.schwarz@gmail.com, linux@alteeve.com, scrawford@pinpointresearch.com, bnichols@ca.afilias.info, gpd@gpdnet.co.uk
Subject: Re: DB is slow until DB is reloaded
In-Reply-To: <37d451f71001041406i3f5d8d5fte8a29cfbc06998c9@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