"Overlaping" indexes - Mailing list pgsql-performance

From Rigmor Ukuhe
Subject "Overlaping" indexes
Date
Msg-id OEEHLFAIJHHMABJPIANICEBOCIAA.rigmor.ukuhe@finestmedia.com
Whole thread Raw
Responses Re: "Overlaping" indexes
List pgsql-performance
Hi,

I have many indexes somehow overlaping like:
... btree ("STATUS", "VISIBLE", "NP_ID");
... btree ("STATUS", "VISIBLE");

is perfomance gained by "more exact" index worth overhead with managing
indexes.

Rigmor Ukuhe
Finestmedia Ltd
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.564 / Virus Database: 356 - Release Date: 19.01.2004


pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: views?
Next
From: Tomasz Myrta
Date:
Subject: Re: "Overlaping" indexes