Postgres Pro
Downloads
Home   >   mailing lists

COPY with INDEXES question - Mailing list pgsql-performance

From Slavisa Garic
Subject COPY with INDEXES question
Date
Msg-id Pine.GSO.4.10.10402061143430.29801-100000@bruce.csse.monash.edu.au
Whole thread Raw
Responses Re: COPY with INDEXES question
Re: COPY with INDEXES question
List pgsql-performance
Tree view 
Hi,

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?

Thanks,
Slavisa

pgsql-performance by date:

Previous
From: Mark Harrison
Date:
Subject: Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: COPY with INDEXES question