Which indexes to drop

From: John Taylor <postgres(at)jtresponse(dot)co(dot)uk>
To: "PgSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Which indexes to drop
Date: 2002-06-18 14:03:53
Message-ID: 02061815035401.01632@splash.hq.jtresponse.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Hi,

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 ?
What will happen to the constraint checking ?

How do I create them again afterwards, so that they are used correctly for constraint checking ?

Say I have a table:

create table transmission (
id serial not null,
start timestamp not null default CURRENT_TIMESTAMP,
stop timestamp,
complete boolean not null default false,
primary key(id,complete)
)

This will have an index:
transmission_pkey

After data loading can I create it again as follows ?

CREATE INDEX transmission_pkey ON transmission(id,complete)

Thanks
JohnT

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message John Taylor 2002-06-18 15:19:15 What gets inherited
Previous Message Manfred Koizar 2002-06-18 09:38:44 Re: function delete problems