From: | Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)ru> |
---|---|
To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
Cc: | PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #3261: autovacuum starts regarding config setting |
Date: | 2007-05-04 11:30:37 |
Message-ID: | 20070504153037.ce674e36.eugrid@fpm.kubsu.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Heikki,
Yes, I did restart postmaster after setting autovacuum=off
as I've mentioned before I've checked it using show autovacuum.
It was vacuuming a table from the old database while
the server was running pg_dump -U postgres old_base | psql new_base postgres
Sorry for missing the CC, I had a bad night sleep (actually dump-restored db =)
On Fri, 04 May 2007 11:57:25 +0100
Heikki Linnakangas <heikki(at)enterprisedb(dot)com> wrote:
> Please CC the list to allow others to participate in the discussion, and
> to have it archived for future readers...
>
> Evgeny Gridasov wrote:
> > I've seen it analyzing and vacuuming some tables for a long time...
> > Is it OK?
> > The reason I'm asking I was dump-restoring a huge database, and disabled
> > autovacuum in config file.
>
> Well, to avoid XID wrap-around, you have to run (auto)vacuum eventually.
> If you don't mind that your clog files will take up more disk space, as
> you probably don't if you have a huge database anyways, you can increase
> autovacuum_freeze_max_age so you don't need to run it as often.
>
> But I'm starting to wonder if it was the XID wraparound that triggered
> the autovacuum after all. You did restart postmaster after setting
> autovacuum=off in the config file, right? That's required for the
> setting to take effect.
>
> What table is it vacuuming? A recently restored table shouldn't need to
> be vacuumed for a long time.
>
> --
> Heikki Linnakangas
> EnterpriseDB http://www.enterprisedb.com
>
From | Date | Subject | |
---|---|---|---|
Next Message | DNS | 2007-05-04 13:54:23 | Re: PGSQL - WARNING: 25P01: there is no transaction in progress |
Previous Message | Heikki Linnakangas | 2007-05-04 10:57:25 | Re: BUG #3261: autovacuum starts regarding config setting |