Scott Whitney <sc...@journyx.com> writes:
> I understand the purpose of the clogs, but I would think that the
> transactions would have been frozen on all dbs (I've got about 300 in my
> cluster) by now. My logs go back to July 13th which, I think, is when the
> server was last restarted.
It doesn't really try to remove clog entries that are younger than
vacuum_freeze_table_age (see also vacuum_freeze_min_age). At two bits
per transaction, the general feeling is that eating the disk space is
better than forcing full-database vacuums more often. But if you're
hot to have the space released sooner, those are the knobs to frob.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
