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