Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B6A6C475AD4 for ; Sat, 25 Jan 2003 14:07:36 -0500 (EST) Received: from jester.senspire.com (CPE00508b028d7d-CM00803785c5e0.cpe.net.cable.rogers.com [24.103.51.175]) by postgresql.org (Postfix) with ESMTP id CE468474E61 for ; Sat, 25 Jan 2003 14:07:35 -0500 (EST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by jester.senspire.com (8.12.6/8.12.6) with ESMTP id h0PJ7kqu081649; Sat, 25 Jan 2003 14:07:46 -0500 (EST) (envelope-from rbt@rbt.ca) Subject: Re: LOCK TABLE & speeding up mass data loads From: Rod Taylor To: Ron Johnson Cc: PgSQL Performance ML In-Reply-To: <1043521053.818.32.camel@haggis> References: <1043521053.818.32.camel@haggis> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-SoMw60ebdgyBE0D1x2w5" Organization: Message-Id: <1043521665.58142.135.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 25 Jan 2003 14:07:46 -0500 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/332 X-Sequence-Number: 979 --=-SoMw60ebdgyBE0D1x2w5 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Sat, 2003-01-25 at 13:57, Ron Johnson wrote: > Hi, >=20 > Would LOCK TABLE ACCESS EXCLUSIVE MODE speed things up, when I have > a script that loads data by setting transactions, and then committing > works after every few thousand INSERTs? If you're the only person working on the database, then no. If you're fighting for resources with a bunch of other people -- then possibly, but the others won't get anything done during this timeframe (of course). Oh, and you're using COPY right? --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-SoMw60ebdgyBE0D1x2w5 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (FreeBSD) iD8DBQA+MuCB6DETLow6vwwRAsQeAJ97EljImU0a+5PVu8zynHY+xg6kqgCfZU9F rqHwa5faLDcJkakZX0gOMbI= =cJNP -----END PGP SIGNATURE----- --=-SoMw60ebdgyBE0D1x2w5--