Re: pg_log

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sylvain Simard <sylvain@luxolith.com>
Cc: pgsql-bugs@postgresql.org
Date: 2000-10-26T04:43:23Z
Lists: 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