Re: [Fwd: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum]

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [Fwd: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum]
Date: 2007-06-04 13:19:41
Message-ID: 20070604131941.GJ32320@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 01, 2007 at 01:27:14PM -0700, Ron St-Pierre wrote:
> imp=# select age(datfrozenxid) from pg_database where datname = 'imp';
> age
> ------------
> 1571381411
> (1 row)
>
> Time to start VACUUM FULL ANALYZE over the weekend.

I guess this comes too late, but you don't need VACUUM FULL for that.
VACUUM FULL _does not_ mean "vacuum everything"!

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
Unfortunately reformatting the Internet is a little more painful
than reformatting your hard drive when it gets out of whack.
--Scott Morris

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2007-06-04 13:25:05 Re: High-availability
Previous Message Ray Stell 2007-06-04 12:31:52 Re: Tablespaces