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 ABFB9D839E for ; Fri, 9 Sep 2005 13:02:46 -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 24308-08 for ; Fri, 9 Sep 2005 16:02:42 +0000 (GMT) Received: from hotmail.com (bay108-f11.bay108.hotmail.com [65.54.162.21]) by svr1.postgresql.org (Postfix) with ESMTP id 4C751D834F for ; Fri, 9 Sep 2005 13:02:39 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 9 Sep 2005 09:02:33 -0700 Message-ID: Received: from 65.54.162.200 by by108fd.bay108.hotmail.msn.com with HTTP; Fri, 09 Sep 2005 16:02:33 GMT X-Originating-IP: [207.236.65.226] X-Originating-Email: [kevinrkeith@hotmail.com] X-Sender: kevinrkeith@hotmail.com From: "Kevin Keith" To: pgsql-admin@postgresql.org Subject: Disabling WAL for bulk data loads Date: Fri, 09 Sep 2005 11:02:33 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 09 Sep 2005 16:02:34.0014 (UTC) FILETIME=[E3E4EBE0:01C5B557] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.144 required=5 tests=[AWL=-0.438, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0, RCVD_IN_BL_SPAMCOP_NET=1.832] X-Spam-Level: *** X-Archive-Number: 200509/97 X-Sequence-Number: 18834 I am coming from an Oracle background - which in the case of bulk data loads there were several options I had where I could disable writing to the redo log to speed up the bulk data load (i.e. direct load, set the user session in no archive logging, set the affected tables to have no logging). I know the COPY command is one option - however it appears the data would need to be in formatted file in order to use it correct? I want to avoid writing a new file out for the COPY command and loading that. What other options does Postgres 7.4 provide which would allow data loads to bypass writing to the WAL? I don't need to have this enabled - because in the event of a database crash, I would simply reload the data from the source files as recovery. Thanks, Kevin _________________________________________________________________ Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/