Horton

Re: COPY with INDEXES question

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

View thread View on postgr.es
From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>
Cc: pgsql-performance@postgresql.org
Date: 2004-02-06T02:54:12Z
Lists: pgsql-hackers, pgsql-performance 
> 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?

Yes, of course.  Runs triggers and stuff as well.

Chris