Re: pg_log - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_log
Date
Msg-id 6990.983907079@sss.pgh.pa.us
Whole thread Raw
In response to pg_log  (Alvaro Herrera <alvherre@protecne.cl>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Francis Solomon"
Date:
Subject: RE: [SQL] Date question
Next
From: "Martin A. Marques"
Date:
Subject: Re: PostgreSQL 7 on Solaris 8 - Is it working?