Postgres Pro
Downloads
Home   >   mailing lists

COPY ... FROM and index usage - Mailing list pgsql-general

From Reg Me Please
Subject COPY ... FROM and index usage
Date
Msg-id 200711041122.19843.regmeplease@gmail.com
Whole thread Raw
Responses Re: COPY ... FROM and index usage  ("Josh Tolley" <eggyknap@gmail.com>)
Re: COPY ... FROM and index usage  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-general
Tree view 
Hi all.

I'd like to know whether the indexes on a table are updated or not during
a "COPY ... FROM" request.

That is, should I drop all indexes during a "COPY ... FROM" in order to gain
the maximum speed to load data?

Thanks.

--
Reg me Please

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: What makes a Postgres DBA?
Next
From: Julio Cesar Sánchez González
Date:
Subject: Re: Copy the database..