Thread: [GENERAL] Old pg_clog files
Hi,
v8.4.17
http://www.postgresql-archive.org/pg-clog-questions-td2080911.html
According to this old thread, doing a VACUUM on every table in the postgres, template1 and TAPd databases should remove old pg_clog files.
However, while about 40 of them have been deleted, 183 still exist. What did I do wrong?
Thanks
v8.4.17
http://www.postgresql-archive.org/pg-clog-questions-td2080911.html
According to this old thread, doing a VACUUM on every table in the postgres, template1 and TAPd databases should remove old pg_clog files.
postgres=# SELECT datname, age(datfrozenxid) FROM pg_database;
datname | age
-----------+-----------
template1 | 9951058
template0 | 9814761
postgres | 163406258
TAPd | 179543997
(4 rows)
However, while about 40 of them have been deleted, 183 still exist. What did I do wrong?
Thanks
-- World Peace Through Nuclear Pacification
On Sunday, October 29, 2017, Ron Johnson <ron.l.johnson@cox.net> wrote:
Hi,
v8.4.17
http://www.postgresql-archive.org/pg-clog-questions- td2080911.html
According to this old thread, doing a VACUUM on every table in the postgres, template1 and TAPd databases should remove old pg_clog files.
However, while about 40 of them have been deleted, 183 still exist. What did I do wrong?
Reading the old thread it sounds like it might require multiple vacuums to affect complete removal.
David J.
On 10/29/2017 03:37 PM, David G. Johnston wrote:
On Sunday, October 29, 2017, Ron Johnson <ron.l.johnson@cox.net> wrote:Hi,
v8.4.17
http://www.postgresql-archive.org/pg-clog-questions- td2080911.html
According to this old thread, doing a VACUUM on every table in the postgres, template1 and TAPd databases should remove old pg_clog files.
However, while about 40 of them have been deleted, 183 still exist. What did I do wrong?
Reading the old thread it sounds like it might require multiple vacuums to affect complete removal.
I vacuumed them twice.
Does it matter whether I ran a VACUUM ANALYZE on every table instead of "vacuumdb --all"?
-- World Peace Through Nuclear Pacification