COPY ... FROM and index usage

From: Reg Me Please <regmeplease(at)gmail(dot)com>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: COPY ... FROM and index usage
Date: 2007-11-04 10:22:19
Message-ID: 200711041122.19843.regmeplease@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julio Cesar Sánchez González 2007-11-04 11:24:29 Re: Copy the database..
Previous Message Greg Smith 2007-11-04 09:18:59 Re: What makes a Postgres DBA?