Re: COPY ... FROM and index usage

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Josh Tolley" <eggyknap(at)gmail(dot)com>
Cc: "Reg Me Please" <regmeplease(at)gmail(dot)com>, "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: COPY ... FROM and index usage
Date: 2007-11-04 16:15:05
Message-ID: 14164.1194192905@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Josh Tolley" <eggyknap(at)gmail(dot)com> writes:
> Although questions of "which is faster" often depend very heavily on
> the data involved, the database schema, the hardware, etc., typically
> people find it best to drop all indexes during a large import and
> recreate them afterward.

See also the extensive discussion of this topic at

http://www.postgresql.org/docs/8.2/static/populate.html

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dimitri Fontaine 2007-11-04 18:01:55 Re: COPY ... FROM and index usage
Previous Message Tom Lane 2007-11-04 16:09:01 Re: Would an index benefit select ... order by?