Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7F7DC9FB57E for ; Fri, 18 May 2007 02:31:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 02013-01 for ; Fri, 18 May 2007 02:31:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pro33.abac.com (pro33.abac.com [66.226.64.34]) by postgresql.org (Postfix) with ESMTP id 88E5B9FB545 for ; Fri, 18 May 2007 02:31:09 -0300 (ADT) Received: from ashishk (ppp92-7.vsnl.eth.net [61.17.93.7] (may be forged)) (authenticated bits=0) by pro33.abac.com (8.13.8/8.13.8) with ESMTP id l4I5Ur26015123 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Thu, 17 May 2007 22:31:00 -0700 (PDT) (envelope-from ashish.karalkar@info-spectrum.com) Message-ID: <005601c7990d$1acbfff0$170211ac@LIONKING.COM> From: "Ashish Karalkar" To: "Khan, Mahmood Ahram" Cc: References: <000e01c79882$c7fc7550$170211ac@LIONKING.COM> <002a01c79908$b2ce4880$170211ac@LIONKING.COM> Subject: Re: WAL FILES Date: Fri, 18 May 2007 10:56:27 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0051_01C7993B.2EF4E4F0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/176 X-Sequence-Number: 25496 This is a multi-part message in MIME format. ------=_NextPart_000_0051_01C7993B.2EF4E4F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I give you idea to reduce archive time out parameter just to check = wether archiving is working or not. Yes you are right,PostgreSQL will generate 16 MB of WAL file each time. = So if u keep para archive timeout to 0 then after filling 16 MB data in = WAL file postgre will switch over to new file.