X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A4A8CD1CB0F for ; Fri, 6 Feb 2004 02:55:17 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 00159-05 for ; Thu, 5 Feb 2004 22:55:18 -0400 (AST) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2DFBDD1CA67 for ; Thu, 5 Feb 2004 22:55:14 -0400 (AST) Received: from [134.22.70.253] (dyn-70-253.tor.dsl.tht.net [134.22.70.253]) by tht.net (Postfix) with ESMTP id C78F676A2A; Thu, 5 Feb 2004 21:55:21 -0500 (EST) Subject: Re: COPY with INDEXES question From: Rod Taylor To: Slavisa Garic Cc: Postgresql Performance In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-XjcbCDOxoJ/XCmYGop3A" Message-Id: <1076036127.308.586.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Thu, 05 Feb 2004 21:55:28 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/97 X-Sequence-Number: 5621 --=-XjcbCDOxoJ/XCmYGop3A Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Thu, 2004-02-05 at 19:46, Slavisa Garic wrote: > Hi, >=20 > I have a quick question. In order to speed up insertion of large number of > rows (100s of thousands) I replaced the INSERT with the COPY. This works > fine but one question popped into my mind. Does copy updates indexes on > that table if there are some defined? Copy does nearly everything that standard inserts to. RULES are the only thing that come to mind. Triggers, indexes, constraints, etc. are all applied. --=20 Rod Taylor Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL PGP Key: http://www.rbt.ca/rbtpub.asc --=-XjcbCDOxoJ/XCmYGop3A Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD8DBQBAIwIf6DETLow6vwwRAvKwAJ9TIi35EL0mwMbQZXwRoRhSxkF+vQCaAkKL nRWDxCgBjiY/FGA3I80VOOo= =W+US -----END PGP SIGNATURE----- --=-XjcbCDOxoJ/XCmYGop3A--