From: | Reg Me Please <regmeplease(at)gmail(dot)com> |
---|---|
To: | "Josh Tolley" <eggyknap(at)gmail(dot)com> |
Cc: | "Postgres General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: COPY ... FROM and index usage |
Date: | 2007-11-04 15:15:33 |
Message-ID: | 200711041615.33405.regmeplease@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Il Sunday 04 November 2007 14:59:10 Josh Tolley ha scritto:
> On 11/4/07, Reg Me Please <regmeplease(at)gmail(dot)com> wrote:
> > 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.
>
> 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.
>
> - Josh/eggyknap
This sounds very reasonable to me.
But the first question remains unanswered:
Are the indexes updated during the COPY ... FROM ?
Thanks again.
--
Reg me Please
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Jones | 2007-11-04 15:21:41 | Re: COPY ... FROM and index usage |
Previous Message | Josh Tolley | 2007-11-04 13:59:10 | Re: COPY ... FROM and index usage |