COPY with INDEXES question

From: Slavisa Garic <Slavisa(dot)Garic(at)infotech(dot)monash(dot)edu(dot)au>
To: pgsql-performance(at)postgresql(dot)org
Subject: COPY with INDEXES question
Date: 2004-02-06 00:46:57
Message-ID: Pine.GSO.4.10.10402061143430.29801-100000@bruce.csse.monash.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Hi,

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?

Thanks,
Slavisa

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-02-06 01:11:25 Re: It's past time to redo the smgr API
Previous Message Marc G. Fournier 2004-02-05 23:54:17 Re: It's past time to redo the smgr API

Browse pgsql-performance by date

  From Date Subject
Next Message Slavisa Garic 2004-02-06 02:52:28 Re: COPY with INDEXES question
Previous Message Mark Harrison 2004-02-05 23:09:36 Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?