Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 01E35475425 for ; Mon, 27 Jan 2003 04:56:48 -0500 (EST) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by postgresql.org (Postfix) with ESMTP id 05B14476099 for ; Mon, 27 Jan 2003 04:56:45 -0500 (EST) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h0R9ujO18925 for ; Mon, 27 Jan 2003 15:26:45 +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 h0R9uj718920 for ; Mon, 27 Jan 2003 15:26:45 +0530 From: "Shridhar Daithankar" To: PgSQL Performance ML Date: Mon, 27 Jan 2003 15:27:05 +0530 MIME-Version: 1.0 Subject: Re: LOCK TABLE & speeding up mass data loads Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3E354FC9.21573.A43098B@localhost> In-reply-to: <3E354CFB.32732.A38120C@localhost> References: <1043658500.818.398.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/346 X-Sequence-Number: 993 On 27 Jan 2003 at 15:15, Shridhar Daithankar wrote: > IIRc, there is a hook to \copy, not the postgreSQL command copy for how many > 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. > > DOn't have a postgresql installation handy, me being in linux, but this is > definitely possible.. I am sleeping. That should have read XP rather than linux. Grrr.. Bye Shridhar -- Lowery's Law: If it jams -- force it. If it breaks, it needed replacing anyway.