X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C65543A1AF4 for ; Sat, 15 Jan 2005 00:32:02 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43277-06 for ; Sat, 15 Jan 2005 00:31:50 +0000 (GMT) Received: from sj-iport-5.cisco.com (sj-iport-5.cisco.com [171.68.10.87]) by svr1.postgresql.org (Postfix) with ESMTP id 529BF3A198B for ; Sat, 15 Jan 2005 00:31:52 +0000 (GMT) Received: from sj-core-3.cisco.com (171.68.223.137) by sj-iport-5.cisco.com with ESMTP; 14 Jan 2005 16:31:56 -0800 X-BrightmailFiltered: true X-Brightmail-Tracker: AAAAAA== Received: from cjwhitew2k02 (sjc-vpn2-198.cisco.com [10.21.112.198]) by sj-core-3.cisco.com (8.12.10/8.12.6) with ESMTP id j0F0VoRO019354 for ; Fri, 14 Jan 2005 16:31:51 -0800 (PST) Message-Id: <200501150031.j0F0VoRO019354@sj-core-3.cisco.com> Reply-To: From: "Chris White (cjwhite)" To: Subject: Limiting size and number of transaction logs Date: Fri, 14 Jan 2005 16:31:50 -0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01D1_01C4FA56.8D07B300" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Thread-Index: AcT6mZqPnXxWmJUQRo63biwZRB7o2A== X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.518 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200501/156 X-Sequence-Number: 16015 This is a multi-part message in MIME format. ------=_NextPart_000_01D1_01C4FA56.8D07B300 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit In the documentation for 7.4 for WAL configuration, I see the following statement: There will be at least one 16 MB segment file, and will normally not be more than 2 * checkpoint_segments + 1 files. So if I have 1 checkpoint segment configured, does this mean there will be a max of 4 16MB files or 3 16MB files. Is there anyway of reducing this number of files, as I am running on a system which is very tight on disk space and doesn't have that much DB transaction throughput that needs this number of transaction logs or is there a way of making the size smaller? Chris White ------=_NextPart_000_01D1_01C4FA56.8D07B300 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
In the = documentation=20 for 7.4 for WAL configuration, I see the following=20 statement:
 
There will be at least one 16 MB segment file, = and will=20 normally not be more than 2 * checkpoint_segments = + 1=20 files.
 
So if = I have 1=20 checkpoint segment configured, does this mean there will be a max of 4 = 16MB=20 files or 3 16MB files.
 
Is = there anyway of=20 reducing this number of files, as I am running on a system which is very = tight=20 on disk space and doesn't have that much DB transaction  throughput = that=20 needs this number of transaction logs or is there a way of making the = size=20 smaller?
 
Chris=20 White
------=_NextPart_000_01D1_01C4FA56.8D07B300--