"Overlaping" indexes

From: "Rigmor Ukuhe" <rigmor(dot)ukuhe(at)finestmedia(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: "Overlaping" indexes
Date: 2004-02-02 14:46:22
Message-ID: OEEHLFAIJHHMABJPIANICEBOCIAA.rigmor.ukuhe@finestmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomasz Myrta 2004-02-02 15:05:57 Re: "Overlaping" indexes
Previous Message Richard Huxton 2004-02-02 09:48:21 Re: views?