Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY with INDEXES question - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: COPY with INDEXES question
Date
Msg-id 402301D4.8030604@familyhealth.com.au
Whole thread Raw
In response to COPY with INDEXES question  (Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>)
Responses Re: COPY with INDEXES question
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Slavisa Garic
Date:
Subject: COPY with INDEXES question
Next
From: Slavisa Garic
Date:
Subject: Re: COPY with INDEXES question