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
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 |