Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7C3064762C6 for ; Mon, 27 Jan 2003 05:00:17 -0500 (EST) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by postgresql.org (Postfix) with ESMTP id A23E54762BE for ; Mon, 27 Jan 2003 05:00:15 -0500 (EST) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h0RA0J219361 for ; Mon, 27 Jan 2003 15:30:19 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h0RA0J719356 for ; Mon, 27 Jan 2003 15:30:19 +0530 From: "Shridhar Daithankar" To: PgSQL Performance ML Date: Mon, 27 Jan 2003 15:30:39 +0530 MIME-Version: 1.0 Subject: Re: LOCK TABLE & speeding up mass data loads Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3E35509F.29103.A464C91@localhost> References: <3E354CFB.32732.A38120C@localhost> In-reply-to: <1043661264.9231.8.camel@haggis> X-mailer: Pegasus Mail for Windows (v4.02) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/347 X-Sequence-Number: 994 On 27 Jan 2003 at 3:54, Ron Johnson wrote: > On Mon, 2003-01-27 at 03:45, Shridhar Daithankar wrote: > > transactions you would like to see. I remember to have benchmarked that and > > concluded that doing copy in one transaction is the fastest way of doing it. > > Boy Scout motto: Be prepared!! (Serves me well as a DBA.) Goes for everything else as well.. > > So it takes a little longer. In case of failure, the time would be > more than made up. Also, wouldn't the WAL grow hugely if many millions > of rows were inserted in one txn? Nops.. If WAL starts recycling, postgresql should start flishing data from WAL to data files. At any given moment, WAL will not exceed of what you have configured. They are just read ahead logs most of the times intended for crash recovery. (Consequently it does not help setting WAL bigger than required.) Bye Shridhar -- nominal egg: New Yorkerese for expensive.