Re: why does explain tell me I'm using a seq scan?

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Mark Harrison <mh(at)pixar(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: why does explain tell me I'm using a seq scan?
Date: 2003-11-08 00:19:24
Message-ID: 1068250763.61532.6.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2003-11-07 at 19:11, Mark Harrison wrote:
> I have indexed two columns in a table. Can somebody explain to me why
> the first query below uses an Index Scan while the second uses a Seq
> Scan?

The first expects to find a single row, the second expects to find 17000
rows, a significant portion of the table where an index scan would be a
loss based on current tuning parameters.

--
Rod Taylor <pg [at] rbt [dot] ca>

Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Ruth 2003-11-08 00:33:44 Re: why does explain tell me I'm using a seq scan?
Previous Message Mark Harrison 2003-11-08 00:11:58 why does explain tell me I'm using a seq scan?