Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum does not stay turned off - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: Autovacuum does not stay turned off
Date
Msg-id 20080826162144.GX10936@commandprompt.com
Whole thread Raw
In response to Autovacuum does not stay turned off  (Jerry Champlin <jchamplin@absolute-performance.com>)
List pgsql-performance
Tree view 
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@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

pgsql-performance by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Autovacuum does not stay turned off
Next
From: "Frank Joerdens"
Date:
Subject: Query w empty result set with LIMIT orders of magnitude slower than without