Re: URGENT: Performance tuning

From: Curt Sampson <cjs(at)cynic(dot)net>
To: Ericson Smith <eric(at)did-it(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: URGENT: Performance tuning
Date: 2002-06-22 09:23:45
Message-ID: Pine.NEB.4.43.0206221822440.1091-100000@angelic.cynic.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Varun Kacholia 2002-06-22 09:47:24 COPY problem
Previous Message Curt Sampson 2002-06-22 09:17:41 Re: shared memory