Skip site navigation (1) Skip section navigation (2)

Re: Query not using the index

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Mark Halliwell <mark(at)transportservices(dot)com(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query not using the index
Date: 2003-02-25 13:56:29
Message-ID: 20030225135629.GA30236@wolff.to (view raw or flat)
Thread:
Lists: pgsql-performance
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 LaneDate: 2003-02-25 15:13:26
Subject: Re: Query not using the index
Previous:From: Andrew SullivanDate: 2003-02-25 12:44:50
Subject: Re: Query not using the index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group