Re: pg_log

Alvaro Herrera <alvherre@protecne.cl> writes:
> ARAIK, pg_log records which tuples are "active" and which ones are
> obsolete, so I'm not going to delete it.

Actually, it records which transactions committed and which didn't.
So, you can slow the rate of growth of pg_log if you can reduce the
number of transactions used.  Consider wrapping sequences of operations
into begin/end blocks.

> I know I can dump and restore from a clean (empty) install,
> but is there a simpler way?

Afraid not.  pg_log is critical data.

            regards, tom lane