Received: from mblox.com (unknown [213.155.153.59]) by postgresql.org (Postfix) with ESMTP id 38C32475A3E for ; Mon, 8 Apr 2002 08:45:48 -0400 (EDT) Received: from salamander (salamander.mblox.com [::ffff:192.168.2.102]) (AUTH: LOGIN ian.cass) by aerosmith with esmtp; Mon, 08 Apr 2002 12:46:21 +0000 Message-ID: <002d01c1defb$23603630$6602a8c0@salamander> From: "Ian Cass" To: pgsql-sql@postgresql.org References: <002001c1def9$e0fcc750$6602a8c0@salamander> Subject: Re: JOINS and non use of indexes Date: Mon, 8 Apr 2002 13:44:34 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/83 X-Sequence-Number: 7348 Of course, the messages index looks like this... CREATE INDEX messages_200204_ix2 ON messages_200204 USING btree (client_id, user_name); Duh! > -- Index: messages_200204_ix1 > CREATE UNIQUE INDEX messages_200204_ix1 ON messages_200204 USING btree