From: | Dushyanth <dushyanth(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [Postgresql 8.2.3] autovacuum starting up even after disabling ? |
Date: | 2008-07-07 16:49:06 |
Message-ID: | loom.20080707T164105-207@post.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hey,
> Tom Lane <tgl <at> sss.pgh.pa.us> writes:
> > Dushyanth <dushyanth <at> gmail.com> writes:
> >> Does "show autovacuum" confirm that it's off?
>
> > Yes.
>
> > # show autovacuum;
> > autovacuum
> > ------------
> > off
> > (1 row)
>
> Then the only other possibility is that autovacuum is being launched to
> prevent XID wraparound. Are there any tables in that database with
> particularly old relfrozenxid? Try something like
>
> select relname, age(relfrozenxid) from pg_class
> where relkind in ( 'r', 't') order by 2 desc;
Below are the unique age(relfrozenxid) values that i see from the above query
# psql -U postgres -d dbname -c "select relname, age(relfrozenxid) from pg_class
where relkind in ( 'r', 't') order by 2 desc;" | awk '{print $3}' | sort | uniq
140835139
150945753
185741480
They are all under 200 million - Also please refer to
http://archives.postgresql.org/pgsql-general/2008-07/msg00195.php. I have
provided more details in here.
Thanks
Dushyanth
From | Date | Subject | |
---|---|---|---|
Next Message | salman Sheikh | 2008-07-07 17:43:31 | Replacing MS Access with Postgresql |
Previous Message | Scott Ribe | 2008-07-07 16:33:36 | Re: creating "a perfect sequence" column |