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 67102D1D2DB for ; Mon, 2 Feb 2004 18:40:50 +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 28898-07 for ; Mon, 2 Feb 2004 14:40:47 -0400 (AST) Received: from serwer.skawsoft.com.pl (skawina.eu.org [80.48.213.66]) by svr1.postgresql.org (Postfix) with ESMTP id 27E04D1D299 for ; Mon, 2 Feb 2004 14:40:46 -0400 (AST) Received: from klaster.net (core-1.citynet.pl [80.48.135.14]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 50CFC2B3CB; Mon, 2 Feb 2004 19:40:43 +0100 (CET) Message-ID: <401E9A37.1070909@klaster.net> Date: Mon, 02 Feb 2004 19:43:03 +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: "scott.marlowe" Cc: Rigmor Ukuhe , 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/7 X-Sequence-Number: 5531 Dnia 2004-02-02 19:30, Użytkownik scott.marlowe napisał: > Not entirely, since it only has to sort two columns, it will be smaller, > and will therefore be somewhat faster. Can you say something more about it? Will it be enough faster to keep them both? Did anyone make such tests? Regards, Tomasz Myrta