From: Scott Marlowe <scott.marlowe@gmail.com>
To: Adrian Moisey <adrian@careerjunction.co.za>
Cc: pgsql-performance@postgresql.org
Subject: Re: analyze
Date: Tue, 29 Jan 2008 12:36:46 -0600
Message-ID: <dcc563d10801291036g1a24c63dy73756bd24ac69522@mail.gmail.com> (raw)
In-Reply-To: <479F381D.4000809@careerjunction.co.za>
References: <479F381D.4000809@careerjunction.co.za>
On Jan 29, 2008 8:28 AM, Adrian Moisey <adrian@careerjunction.co.za> wrote:
> Hi
>
> How long is a piece of string?
>
> While we're at it, how often do I vacuum analyze?
>
> Seriously though, how do I try measure this?
1: Turn on autovacuum.
2: Look up the thread on nagios plugins for pgsql and rip the query
for checking bloat out of it, or alternatively, use NAGIOS I guess. :)
monitor your db for bloat, and if autovacuum isn't keeping up either
set it to be more aggresive, or schedule manual vacuums for the tables
that need it.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, adrian@careerjunction.co.za
Subject: Re: analyze
In-Reply-To: <dcc563d10801291036g1a24c63dy73756bd24ac69522@mail.gmail.com>
References: <479F381D.4000809@careerjunction.co.za> <dcc563d10801291036g1a24c63dy73756bd24ac69522@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