Benjamin Arai wrote: > So, is there a way to defer the index updating until a later period > of time. More specifically, I would like to do several COPIES to a > running database, then afterward force a update on the index via a > vacuum or something similar. Sure, drop the index, do the COPY, and then recreate the index. That is done often. --------------------------------------------------------------------------- > > Benjamin > > On Mar 29, 2007, at 1:03 AM, A. Kretschmer wrote: > > > am Thu, dem 29.03.2007, um 0:13:09 -0700 mailte Benjamin Arai > > folgendes: > >> Hi, > >> > >> If I have a PostgreSQL table with records and logical indexes already > >> created, if I use COPY to load additional data, does the COPY update > >> the indexes during, after, or not at all? > > > > after, i think. > > > > test=# create table foo (id int primary key, name text); > > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > > "foo_pkey" for table "foo" > > CREATE TABLE > > test=*# copy foo from stdin; > > Enter data to be copied followed by a newline. > > End with a backslash and a period on a line by itself. > >>> 1 a > >>> 2 b > >>> 2 c > >>> \. > > ERROR: duplicate key violates unique constraint "foo_pkey" > > CONTEXT: COPY foo, line 3: "2 c" > > test=*# > > > > > > I can type the wrong key and the error occurs later with the finaly \. > > > > > > Andreas > > -- > > Andreas Kretschmer > > Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) > > GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 1: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that > > your > > message can get through to the mailing list cleanly > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
