On Tue, Feb 25, 2003 at 19:03:40 +1100,
Mark Halliwell <mark(at)transportservices(dot)com(dot)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.
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2003-02-25 15:13:26|
|Subject: Re: Query not using the index |
|Previous:||From: Andrew Sullivan||Date: 2003-02-25 12:44:50|
|Subject: Re: Query not using the index|