Re: Autovacuum does not stay turned off

From: Andrew Sullivan <ajs(at)commandprompt(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum does not stay turned off
Date: 2008-08-26 16:21:44
Message-ID: 20080826162144.GX10936@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Aug 26, 2008 at 09:27:48AM -0600, Jerry Champlin wrote:
>
> Does anyone know what will cause this bahavior for autovacuum?

You're probably approaching the wraparound limit in some database.

If you think you can't afford the overhead when users are accessing
the system, when are you vacuuming?

A

--
Andrew Sullivan
ajs(at)commandprompt(dot)com
+1 503 667 4564 x104
http://www.commandprompt.com/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Frank Joerdens 2008-08-26 16:37:32 Query w empty result set with LIMIT orders of magnitude slower than without
Previous Message hubert depesz lubaczewski 2008-08-26 16:14:27 Re: Autovacuum does not stay turned off