X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1FB8DD1C512 for ; Mon, 2 Feb 2004 15:04:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 31284-10 for ; Mon, 2 Feb 2004 11:03:59 -0400 (AST) Received: from serwer.skawsoft.com.pl (skawina.eu.org [80.48.213.66]) by svr1.postgresql.org (Postfix) with ESMTP id 45DC4D1D2AC for ; Mon, 2 Feb 2004 11:03:51 -0400 (AST) Received: from klaster.net (backbone.zab.citynet.pl [212.244.6.69]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 7EC032B3CB; Mon, 2 Feb 2004 16:03:38 +0100 (CET) Message-ID: <401E6755.7050806@klaster.net> Date: Mon, 02 Feb 2004 16:05:57 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL; rv:1.6b) Gecko/20031208 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Rigmor Ukuhe Cc: pgsql-performance@postgresql.org Subject: Re: "Overlaping" indexes References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/3 X-Sequence-Number: 5527 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