From: Richard Huxton <dev@archonet.com>
To: Florian Litot <flitot@besancon.sema.slb.com>
To: pgsql-general@postgresql.org
Subject: Re: log file?
Date: Tue, 5 Nov 2002 10:47:39 +0000
Message-ID: <200211051047.40020.dev@archonet.com> (raw)
In-Reply-To: <4.3.2.7.2.20021105095405.023e8910@pop.besancon.tt.slb.com>
References: <1035298174.6559.49.camel@thor>
<4.3.2.7.2.20021105095405.023e8910@pop.besancon.tt.slb.com>
On Tuesday 05 Nov 2002 8:56 am, Florian Litot wrote:
> hi
> i have got a lot of file which is create
> DEBUG: recycled transaction log file 0000000100000037
> DEBUG: recycled transaction log file 0000000100000038
> DEBUG: recycled transaction log file 0000000100000039
> DEBUG: recycled transaction log file 000000010000003A
> DEBUG: recycled transaction log file 000000010000003B
> DEBUG: recycled transaction log file 000000010000003C
> why is it create?
> and what is this folder? pg_xlog
> how i can reduce the number of this files because it takes a lot of place
> thanks
PG writes all transactions to disk before actually making changes so that you
can recover in the event of a crash. It splits this transaction log into
chunks and recycles them when all the transactions it refers to are no longer
of interest.
Read up on WAL for more details and configuration options in the
postgresql.conf file.
--
Richard Huxton
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: dev@archonet.com, flitot@besancon.sema.slb.com
Subject: Re: log file?
In-Reply-To: <200211051047.40020.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox