Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1733F9FB471 for ; Fri, 16 Feb 2007 11:26:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 53534-03 for ; Fri, 16 Feb 2007 11:26:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 089A59FB434 for ; Fri, 16 Feb 2007 11:26:42 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l1GFQQPJ027606; Fri, 16 Feb 2007 10:26:26 -0500 (EST) To: "Achakzai, Omar" cc: pgsql-admin@postgresql.org Subject: Re: pg_xlog and the WAL files In-reply-to: References: Comments: In-reply-to "Achakzai, Omar" message dated "Fri, 16 Feb 2007 12:10:11 +0100" Date: Fri, 16 Feb 2007 10:26:26 -0500 Message-ID: <27605.1171639586@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/235 X-Sequence-Number: 24700 "Achakzai, Omar" writes: > 1. What happens when the file system on which the pg_xlog directly resides,= > completely fills up? Does PostgreSQL wait until free space is available ag= > ain?=20 I believe it'll PANIC and shut down. You won't lose any committed transactions ... but transactions in progress are out of luck. > 2. Our PostgreSQL database (version 8.1.4.) generates almost 20 GB of WAL f= > iles per hour! What are the best practices related to administering large a= > mounts of WAL files? Would it be wise to compress the WAL files?=20 What are your checkpoint settings? Reducing checkpoint frequency is one way to cut the WAL volume. regards, tom lane