From: | Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Which is better Index |
Date: | 2011-04-05 10:26:52 |
Message-ID: | 4D9AEE6C.50006@orkash.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Dear all,
I want to clear my doubts regarding creating several single or a
multi-column indexes.
My table schema is :-
CREATE TABLE svo2( svo_id bigint NOT NULL DEFAULT
nextval('svo_svo_id_seq'::regclass), doc_id integer, sentence_id
integer, clause_id integer, negation integer, subject
charactervarying(3000), verb character varying(3000), "object"
character varying(3000), preposition character varying(3000),
subject_type character varying(3000), object_type
charactervarying(3000), subject_attribute character varying(3000),
object_attribute character varying(3000), verb_attribute character
varying(3000), subject_concept character varying(100), object_concept
character varying(100), subject_sense character varying(100),
object_sense character varying(100), subject_chain character
varying(5000), object_chain character varying(5000), sub_type_id
integer, obj_type_id integer, CONSTRAINT pk_svo_id PRIMARY KEY
(svo_id))WITH ( OIDS=FALSE);
_*Fore.g*_
CREATE INDEX idx_svo2_id_dummy ON svo2 USING btree (doc_id, clause_id,
sentence_id);
or
CREATE INDEX idx_svo2_id_dummy ON svo2 USING btree (doc_id);
CREATE INDEX idx_svo2_id_dummy1 ON svo2 USING btree (clause_id);
CREATE INDEX idx_svo2_id_dummy2 ON svo2 USING btree (sentence_id);
Which is better if a query uses all three columns in join where clause.
Thanks & best regards,
Adarsh Sharma
From | Date | Subject | |
---|---|---|---|
Next Message | Ákos Gábriel | 2011-04-05 12:31:04 | Re: Postgres Performance Tuning |
Previous Message | Adarsh Sharma | 2011-04-05 07:33:05 | Re: Postgres Performance Tuning |