Re: Query not using the index - Mailing list pgsql-performance

From Bruno Wolff III
Subject Re: Query not using the index
Date
Msg-id 20030225135629.GA30236@wolff.to
Whole thread Raw
In response to Query not using the index  (Mark Halliwell <mark@transportservices.com.au>)
List pgsql-performance
On Tue, Feb 25, 2003 at 19:03:40 +1100,
  Mark Halliwell <mark@transportservices.com.au> wrote:
>
> The majority of records (about 6.8 million) have computer = 8 with sequence
> starting at 2200000 and incrementing by 1.
> There are about 497000 records with computer = 3 with the sequence starting at
> 1 and also incrementing by 1.
> There are only a few records with other computer numbers.

You might get some benefit using a partial index that just covers the
rows where computer = 3.

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Query not using the index
Next
From: Tom Lane
Date:
Subject: Re: Query not using the index