Re: select query not using index

From: "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>
To: vivek(at)staff(dot)ownmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: select query not using index
Date: 2006-12-02 12:54:52
Message-ID: 9e4684ce0612020454l1647ada6lc7ff939255cd54de@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/2/06, vivek(at)staff(dot)ownmail(dot)com <vivek(at)staff(dot)ownmail(dot)com> wrote:
>
> The index was created before the table was populated. There are 3 rows in
> the table for 3 different users. Now when I do a
>

postgresql will not use index scan for table with 3 rows in it. it is way
faster to use seq scan on it.

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-12-02 13:20:50 Re: initdb problem on Windows XP Home
Previous Message A. Kretschmer 2006-12-02 12:32:20 Re: select query not using index