Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8134E47637A for ; Tue, 5 Nov 2002 06:00:09 -0500 (EST) Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net [194.217.242.92]) by postgresql.org (Postfix) with ESMTP id A65EB47629B for ; Tue, 5 Nov 2002 06:00:08 -0500 (EST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-34.mail.demon.net with esmtp (Exim 3.35 #1) id 1891RD-0003Xe-0Y; Tue, 05 Nov 2002 11:00:03 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 7C928174EF; Tue, 5 Nov 2002 10:47:32 +0000 (GMT) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id BF8AA174EE; Tue, 5 Nov 2002 10:47:31 +0000 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: Florian Litot , pgsql-general@postgresql.org Subject: Re: log file? Date: Tue, 5 Nov 2002 10:47:39 +0000 User-Agent: KMail/1.4.3 References: <1035298174.6559.49.camel@thor> <4.3.2.7.2.20021105095405.023e8910@pop.besancon.tt.slb.com> In-Reply-To: <4.3.2.7.2.20021105095405.023e8910@pop.besancon.tt.slb.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200211051047.40020.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/154 X-Sequence-Number: 32575 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 y= ou=20 can recover in the event of a crash. It splits this transaction log into=20 chunks and recycles them when all the transactions it refers to are no long= er=20 of interest. Read up on WAL for more details and configuration options in the=20 postgresql.conf file. --=20 Richard Huxton