Postgres Pro
Downloads
Home   >   mailing lists

Re: JOINS and non use of indexes - Mailing list pgsql-sql

From Ian Cass
Subject Re: JOINS and non use of indexes
Date
Msg-id 002d01c1defb$23603630$6602a8c0@salamander
Whole thread Raw
In response to JOINS and non use of indexes  ("Ian Cass" <ian.cass@mblox.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Ian Cass"
Date:
Subject: JOINS and non use of indexes
Next
From: Jaume Teixi
Date:
Subject: best method for select within all dimensions of an array