Postgres Pro
Downloads
Home   >   mailing lists

Re: select query not using index - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: select query not using index
Date
Msg-id 9e4684ce0612020454l1647ada6lc7ff939255cd54de@mail.gmail.com
Whole thread Raw
In response to select query not using index  (<vivek@staff.ownmail.com>)
List pgsql-general
Tree view
On 12/2/06, vivek@staff.ownmail.com <vivek@staff.ownmail.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

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: select query not using index
Next
From: Richard Huxton
Date:
Subject: Re: initdb problem on Windows XP Home