Re: COPY with INDEXES question

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Slavisa Garic <Slavisa(dot)Garic(at)infotech(dot)monash(dot)edu(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: COPY with INDEXES question
Date: 2004-02-06 02:54:12
Message-ID: 402301D4.8030604@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2004-02-06 02:55:28 Re: COPY with INDEXES question
Previous Message Slavisa Garic 2004-02-06 02:52:28 Re: COPY with INDEXES question

Browse pgsql-performance by date

  From Date Subject
Next Message Rod Taylor 2004-02-06 02:55:28 Re: COPY with INDEXES question
Previous Message Slavisa Garic 2004-02-06 02:52:28 Re: COPY with INDEXES question