Re: Which indexes to drop - Mailing list pgsql-novice

From John Taylor
Subject Re: Which indexes to drop
Date
Msg-id 02061909245601.01538@splash.hq.jtresponse.co.uk
Whole thread Raw
In response to Re: Which indexes to drop  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: Which indexes to drop  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-novice
On Tuesday 18 June 2002 23:51, Ron Johnson wrote:
> On Tue, 2002-06-18 at 10:36, Josh Berkus wrote:
> > John,
> >
> > > I'm optimising my data load by dropping indexes.
> > >
> > > My question is, what do I do with the indexes created by postgres for
> > > primary keys ?
> > >
> > > Is it OK to drop them ?
> >
> > No.
>
> I've done it many times...
>
> alter table t_lane_tx
>     add constraint c_lane_tx_pk primary key (lane_tx_id);
>
> > > How do I create them again afterwards, so that they are used
> > > correctly for constraint checking ?
>
> In this instance, you can have speed or you can have correctness.
> Pick one.  Of course, if you know that your input data is good,
> you have both...
>

I think I'm going to assume that my data is good, otherwise the load will take about 30 hours !

So do I need to:
  remove the constraint
  load
  add the constraint
or
  drop index
  load
  add the constraint


ie:
  Will removing the constraint automatically drop the index
or
  Will dropping the index remove the constraint

Thanks
JohnT

pgsql-novice by date:

Previous
From: John Taylor
Date:
Subject: Re: in_array: Need to specify dimensions
Next
From: Rory Campbell-Lange
Date:
Subject: [repost] trigger update time