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

From Slavisa Garic
Subject Re: COPY with INDEXES question
Date
Msg-id Pine.GSO.4.10.10402061351490.25207-100000@bruce.csse.monash.edu.au
Whole thread Raw
In response to Re: COPY with INDEXES question  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List 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
>
>


pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: COPY with INDEXES question
Next
From: "Octavio Alvarez"
Date:
Subject: Seq scan on zero-parameters function