question about indexing. - Mailing list pgsql-general

From Brian Hirt
Subject question about indexing.
Date
Msg-id 001e01c14a05$f533f740$640b0a0a@berkhirt.com
Whole thread Raw
List pgsql-general
I have a table with about 1 million rows in it.  One of the columns in this
table is some sort of status (it's an int2).  Out of the million rows, only
about 100 of the rows have a status that is not like the rest.

for example:
 999,900 have the value 1
           23 have the value 2
           67 have the value 3
           10 have the value 4

I often want to fetch the rows within that subset of 100.  When i index this
column, the planner always seems to choose a table scan when i query it.
I've tried BTREE and HASH indexes and both do the same thing.

Yes, i do vacuum the table.

Does anyone know how to avoid all these table scans?

Thanks,

Brian


pgsql-general by date:

Previous
From: "Emmanuel SARACCO"
Date:
Subject: number of views supported in 7.1
Next
From: "Andy Hallam"
Date:
Subject: Re: CREATION OF PRIMARY KEYS