pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Stefano Dal Pra <s.dalpra@gmail.com>
Cc: Stéphane Schildknecht <stephane.schildknecht@postgresqlfr.org>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Vacuum goes worse
Date: Wed, 17 Oct 2007 13:07:42 -0300
Message-ID: <20071017160742.GJ5737@alvh.no-ip.org> (raw)
In-Reply-To: <290a5abc0710170735w601b8336v2645e90a54be0e10@mail.gmail.com>
References: <47147AD8.9010704@postgresqlfr.org>
	<15640.1192544768@sss.pgh.pa.us>
	<4714D817.30701@postgresqlfr.org>
	<dcc563d10710160843q3b67e618ua302eb9f1d09b650@mail.gmail.com>
	<18249.1192550596@sss.pgh.pa.us>
	<4715F2ED.20604@postgresqlfr.org>
	<290a5abc0710170735w601b8336v2645e90a54be0e10@mail.gmail.com>

Stefano Dal Pra escribió:
> Your first post says vacuum goes worse (slower).
> I see that you do not issue the -f option (FULL VACUUM).
> 
> I had a similar situation with a server (with frequent update)
> performing nightly vacuumdb. After a few many days it went
> slower and slower.

When you have that problem, the solution is to issue more plain vacuum
(not full) more frequently.  If it's a highly updated table, then maybe
once per hour or more.  It depends on the update rate.

> With psql 8.2.x we adopted pg_autovacuum which seems to perform good,
> even thought
> i do not clearly understand whether it occasionally performs a full
> vacuum (i think he does'nt).

It doesn't because it's normally not necessary.  Also, we don't want to
be acquiring exclusive locks in a background automatic process, so if
you really need vacuum full (and I question your need to) then you must
issue it yourself.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.



view thread (20+ messages)  latest in thread

Message-ID: <20071017160742.GJ5737@alvh.no-ip.org>
Permalink:  ../20071017160742.GJ5737@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20071017160742.GJ5737@alvh.no-ip.org

 · 

reply
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: alvherre@commandprompt.com, s.dalpra@gmail.com, stephane.schildknecht@postgresqlfr.org
  Subject: Re: Vacuum goes worse
  In-Reply-To: <20071017160742.GJ5737@alvh.no-ip.org>

* 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