From: | pchan(at)contigo(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #9447: still bug in autovacuum after upgrading to 9.1.11? |
Date: | 2014-03-05 18:07:58 |
Message-ID: | 20140305180758.1915.10878@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 9447
Logged by: Pius Chan
Email address: pchan(at)contigo(dot)com
PostgreSQL version: 9.1.11
Operating system: Linux version 2.6.18-371.3.1.el5
Description:
After upgrading to 9.1.11, I vacuum the database as instructed in the
release note (i.e. set vacuum_freeze_table_age=0, then run vacuum). I also
run the utility as described in this blog:
However, after a month upgrading to 9.1.11, I run the utility again and
still find rows with strange xmax. The current txid in the system is
1922768288 but I find several rows in a table with xmax <= 5000 and I am
sure some of them were updated after upgrade to 9.1.11. For example:
MY_DB=# select xmin,xmax,* from my_table where xmax=3389;
-[ RECORD 1 ]---+-------------------
xmin | 2
xmax | 3389
id | 35461
name | Speed Over 75 kph
MY_DB=# select relname, relfrozenxid from pg_class where
relname='my_table';
-[ RECORD 1 ]+-----------
relname | my_table
relfrozenxid | 1872725454
I usually fix the bad rows by updating them. However, when I run the utility
every two weeks, I always find rows with exceptionally low xmax again.
Thanks a lot for your help.
Pius
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2014-03-05 18:39:11 | Re: BUG #9447: still bug in autovacuum after upgrading to 9.1.11? |
Previous Message | Tom Lane | 2014-03-05 17:33:28 | Re: BUG #9442: Cannot pg_dump database with event trigger: cannot duplicate null pointer. |