X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ADD0DD8E7F for ; Wed, 14 Sep 2005 15:01:23 -0300 (ADT) 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 06851-05 for ; Wed, 14 Sep 2005 18:01:21 +0000 (GMT) Received: from rwcrmhc11.comcast.net (rwcrmhc11.comcast.net [204.127.198.35]) by svr1.postgresql.org (Postfix) with ESMTP id BCF39D8E74 for ; Wed, 14 Sep 2005 15:01:18 -0300 (ADT) Received: from [192.168.0.100] (c-24-5-74-176.hsd1.ca.comcast.net[24.5.74.176]) by comcast.net (rwcrmhc11) with ESMTP id <2005091418011501300popj4e>; Wed, 14 Sep 2005 18:01:16 +0000 Message-ID: <43286567.6040204@talisys.com> Date: Wed, 14 Sep 2005 11:01:11 -0700 From: William Yu User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: Disabling WAL for bulk data loads References: <6159.1126720694@sss.pgh.pa.us> In-Reply-To: <6159.1126720694@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/166 X-Sequence-Number: 18903 Tom Lane wrote: > William Yu writes: > >>If you have enough memory, you can always make a ramdisk to store the >>WAL temporarily while you bulk load data. I also temporarily alter the >>config to set checkpoint_segments = 1 to use as few pg_xlog files as >>possible. > > > Really? That seems pretty counterproductive to me. I've never seen > a case where reducing checkpoint_segments increased performance. > Checkpoints are expensive, and usually you want 'em far apart. Just poor grammar on my part. I meant decreasing checkpoint_segments when using a ramdisk for WAL in order to keep Postgres from croaking on lack of disk space for pg_xlog.