Re: URGENT: Performance tuning - Mailing list pgsql-general

From Curt Sampson
Subject Re: URGENT: Performance tuning
Date
Msg-id Pine.NEB.4.43.0206221822440.1091-100000@angelic.cynic.net
Whole thread Raw
In response to Re: URGENT: Performance tuning  (Ericson Smith <eric@did-it.com>)
Responses Re: URGENT: Performance tuning
List pgsql-general
On 20 Jun 2002, Ericson Smith wrote:

> For this purpose, you have to have indexes, yes.

Why? Given that there are only five values in the column in question
in a table with over a million rows, the selectivity of the index
would be so low I can't see how postgres would ever use it.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


pgsql-general by date:

Previous
From: Curt Sampson
Date:
Subject: Re: shared memory
Next
From: "Dave Page"
Date:
Subject: Re: foreign Key problem