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 09686D1B563 for ; Wed, 29 Oct 2003 14:04:48 +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 27817-05 for ; Wed, 29 Oct 2003 10:04:19 -0400 (AST) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 7A495D1B556 for ; Wed, 29 Oct 2003 10:04:15 -0400 (AST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id h9TD5LcM019632 for ; Wed, 29 Oct 2003 08:05:23 -0500 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h9TE3vl14918 for ; Wed, 29 Oct 2003 09:03:58 -0500 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id V3JRRANF; Wed, 29 Oct 2003 09:03:55 -0500 Subject: redundent index? From: Robert Treat To: pgsql-performance@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 29 Oct 2003 09:03:56 -0500 Message-Id: <1067436236.2069.28785.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/722 X-Sequence-Number: 4470 I just noticed on one of my tables I have the following two indexes: Indexes: entity_watch_map_pkey primary key btree (entity_id, watch_id), ewm_entity_id btree (entity_id), I can't think of why the second index is there, as ISTM there is no instance where the first index wouldn't be used in place of the second one if i were to delete the second one. its a heavily updated table, so axing the second one would be a bonus for performance, am i missing something? Thanks in advance, Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL