Re: [PERFORM] Partial index usage

On Feb 16, 2009, at 9:07 AM, Craig Ringer wrote: CREATE INDEX uidx_product_partno_producer_id ON product USING btree (partno, producer_id); CREATE INDEX idx_product_partno ON product USING btree (partno); Can I safely delete the second one? You can safely delete BOTH in that it won't h

Re: [PERFORM] Partial index usage

Laszlo Nagy wrote: > Hi All, > > I have these indexes on a table: > > > CREATE INDEX uidx_product_partno_producer_id > ON product > USING btree > (partno, producer_id); > > > CREATE INDEX idx_product_partno > ON product > USING btree > (partno); > > Can I safely delete the second one?

[PERFORM] Partial index usage

Hi All, I have these indexes on a table: CREATE INDEX uidx_product_partno_producer_id ON product USING btree (partno, producer_id); CREATE INDEX idx_product_partno ON product USING btree (partno); Can I safely delete the second one? Will postgresql use (partno,producer_id) when it onl