Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 625252E002F for ; Mon, 18 Feb 2008 05:32:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 12656-04-2 for ; Mon, 18 Feb 2008 05:32:38 -0400 (AST) Received: from depesz.com (depesz.com [88.198.37.40]) by postgresql.org (Postfix) with ESMTP id D8C8D2E003D for ; Mon, 18 Feb 2008 05:32:42 -0400 (AST) Received: from depesz by depesz.com with local (Exim 4.63) (envelope-from ) id 1JR2Ma-0002Et-Pa; Mon, 18 Feb 2008 10:32:40 +0100 Date: Mon, 18 Feb 2008 10:32:40 +0100 From: hubert depesz lubaczewski To: "Kathirvel, Jeevanandam" Cc: pgsql-performance@postgresql.org Subject: Re: Disable WAL completely Message-ID: <20080218093240.GA8568@depesz.com> Reply-To: depesz@depesz.com References: <20080218091940.GA7820@depesz.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/201 X-Sequence-Number: 28743 On Mon, Feb 18, 2008 at 03:00:47PM +0530, Kathirvel, Jeevanandam wrote: > Is there way to minimize the I/O operation on disk/CF. > Can I create RAM file system and point the pg_xlog files to RAM > location instead of CF. whether this will work? it will, but in case you'll lost power you will also (most probably) loose your database. depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV)