Horton

Re: COPY with INDEXES question

Slavisa Garic <slavisa.garic@infotech.monash.edu.au>

View thread View on postgr.es
From: Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>, pgsql-performance@postgresql.org
Date: 2004-02-06T02:52:28Z
Lists: pgsql-hackers, pgsql-performance 
Thanks for the reply and thanks even more for the good one :).

Cheers,
Slavisa

On Fri, 6 Feb 2004, Christopher Kings-Lynne wrote:

> > 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
> 
>