Horton

Re: Old pg_clog files

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Ron Johnson <ron.l.johnson@cox.net>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2017-10-29T20:37:48Z
Lists: pgsql-general 
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.