Thread

1. Old pg_clog files

   Ron Johnson <ron.l.johnson@cox.net> — 2017-10-29T18:45:04Z

   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
   
   

2. Re: Old pg_clog files

   David G. Johnston <david.g.johnston@gmail.com> — 2017-10-29T20:37:48Z

   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.
   

3. Re: Old pg_clog files

   Ron Johnson <ron.l.johnson@cox.net> — 2017-10-29T21:55:25Z

   On 10/29/2017 03:37 PM, David G. Johnston wrote:
   > On Sunday, October 29, 2017, Ron Johnson <ron.l.johnson@cox.net 
   > <mailto:ron.l.johnson@cox.net>> wrote:
   >
   >     Hi,
   >
   >     v8.4.17
   >
   >     http://www.postgresql-archive.org/pg-clog-questions-td2080911.html
   >     <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