Re: pg_log - Mailing list pgsql-bugs

From Tom Lane
Subject Re: pg_log
Date
Msg-id 4538.972535403@sss.pgh.pa.us
Whole thread Raw
In response to pg_log  (Sylvain Simard <sylvain@luxolith.com>)
List pgsql-bugs
Sylvain Simard <sylvain@luxolith.com> writes:
> At begin, with a new database the pg_log are 40k
> After many days my pg_log is come 3884k

pg_log grows at the rate of 2 bits per transaction.

> It's possible to initialize it? If yes how...

dump ... initdb ... reload.

> It's possible to do anything to don't pg_log come bigger and bigger...

Try to use fewer transactions, if two bits per concerns you.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Sean Kelly
Date:
Subject: Re: Updating multiple bool values crashes backend
Next
From: Tom Lane
Date:
Subject: Re: Updating multiple bool values crashes backend