Re: Postgres performs a Seq Scan instead of an Index Scan!

From: Jochem van Dieten <jochemd(at)gmail(dot)com>
To: Jos van Roosmalen <josr(at)josr(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Postgres performs a Seq Scan instead of an Index Scan!
Date: 2004-10-26 16:24:09
Message-ID: f96a9b830410260924533a9560@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kurt Roeckx 2004-10-26 16:32:51 Re: Postgres performs a Seq Scan instead of an Index Scan!
Previous Message James Robinson 2004-10-26 16:23:09 Re: Postgres performs a Seq Scan instead of an Index Scan!