Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres performs a Seq Scan instead of an Index Scan! - Mailing list pgsql-hackers

From Jochem van Dieten
Subject Re: Postgres performs a Seq Scan instead of an Index Scan!
Date
Msg-id f96a9b830410260924533a9560@mail.gmail.com
Whole thread Raw
In response to Postgres performs a Seq Scan instead of an Index Scan!  (Jos van Roosmalen <josr@josr.org>)
List pgsql-hackers
Tree view 
On Tue, 26 Oct 2004 18:12:36 +0200, Jos van Roosmalen wrote:
> 
> I have a little question. Why performs Postgresql a Seq. Scan in the
> next Select statement instead of a Index Read?

That is a FAQ: http://www.postgresql.org/docs/faqs/FAQ.html#4.8


Please direct any further questions of this nature that are not
covered in the FAQ or the documentation to the pgsql-performance list.

Jochem

pgsql-hackers by date:

Previous
From: James Robinson
Date:
Subject: Re: Postgres performs a Seq Scan instead of an Index Scan!
Next
From: Kurt Roeckx
Date:
Subject: Re: Postgres performs a Seq Scan instead of an Index Scan!