From: Brian Hurt <bhurt@janestcapital.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: [Again] Postgres performance problem
Date: Wed, 12 Sep 2007 14:46:01 -0400
Message-ID: <46E833E9.3020001@janestcapital.com> (raw)
In-Reply-To: <dcc563d10709121128o1e5883a9n96b1f9ed74901be9@mail.gmail.com>
References: <46E636CB.8080008@rentalia.com>
<43393.192.121.104.48.1189495883.squirrel@zigo.dhs.org>
<46E64891.9080005@rentalia.com>
<20070911225242.GG38801@decibel.org>
<46E79865.906@rentalia.com>
<dcc563d10709121128o1e5883a9n96b1f9ed74901be9@mail.gmail.com>
Scott Marlowe wrote:
>I'm getting more and more motivated to rewrite the vacuum docs. I
>think a rewrite from the ground up might be best... I keep seeing
>people doing vacuum full on this list and I'm thinking it's as much
>because of the way the docs represent vacuum full as anything. Is
>that true for you?
>
>
>
It's true for me.
I turned off autovacuum as I was getting occassional hangs, which I
thought were the result of vacuums (and have signifigantly decreased
since I did that), and went nightly vacuum fulls, and vacuum
full/reindex/cluster on the weekends (which I now realize is redundant).
Brian
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: bhurt@janestcapital.com, scott.marlowe@gmail.com
Subject: Re: [Again] Postgres performance problem
In-Reply-To: <46E833E9.3020001@janestcapital.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