Re: pg_clog questions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_clog questions
Date: 2006-05-25 20:00:43
Message-ID: 15332.1148587243@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Benjamin Krajmalnik" <kraj(at)illumen(dot)com> writes:
> While checking our server, I noticed quite a few files in the pg_clog
> directory.

> Is there a maintenance task which can be run to purge the files which
> are no longer needed?

VACUUM. If they're not disappearing, you aren't running an adequate
vacuum regime --- missing out some databases, perhaps?

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Krajmalnik 2006-05-25 20:03:40 Re: pg_clog questions
Previous Message Tom Lane 2006-05-25 19:59:21 Re: Strange errors in log file