Horton

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: pgsql-performance@postgresql.org
Date: 2004-02-06T00:46:57Z
Lists: pgsql-hackers, pgsql-performance 
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