Re: "Overlaping" indexes

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Rigmor Ukuhe <rigmor(dot)ukuhe(at)finestmedia(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: "Overlaping" indexes
Date: 2004-02-02 15:05:57
Message-ID: 401E6755.7050806@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dnia 2004-02-02 15:46, Użytkownik Rigmor Ukuhe napisał:
> 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.

The second (2 columns) index is useless - it's function is well done by
the first one (3 columns).

Regards,
Tomasz Myrta

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2004-02-02 17:21:12 MySQL+InnoDB vs. PostgreSQL test?
Previous Message Rigmor Ukuhe 2004-02-02 14:46:22 "Overlaping" indexes