Old pg_clog files

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Old pg_clog files
Date: 2017-10-29 18:45:04
Message-ID: 584a730b-efb8-2832-9a3b-a4f7467f8867@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-10-29 20:37:48 Re: Old pg_clog files
Previous Message Aron Widforss 2017-10-29 18:40:24 Fwd: SPI_palloc problem