Postgres Pro
Downloads
Home   >   mailing lists

Re: Is a better way to have the same result of this - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: Is a better way to have the same result of this
Date
Msg-id 20021205145750.V4800@mail.libertyrms.com
Whole thread Raw
In response to Re: Is a better way to have the same result of this  (Vernon Wu <vernonw@gatewaytech.com>)
Responses Re: Is a better way to have the same result of this  (Vernon Wu <vernonw@gatewaytech.com>)
List pgsql-performance
Tree view 
On Thu, Dec 05, 2002 at 11:08:17AM -0800, Vernon Wu wrote:
> Ron,
>
> The gender is indexed.

Given that gender only has two (?  Very few, anyway) values, I can't
believe an index will be much use: it's not very selective.  Maybe
combining several columns in one index will help you.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

pgsql-performance by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: Is a better way to have the same result of this
Next
From: Vernon Wu
Date:
Subject: Re: Is a better way to have the same result of this