Re: [GENERAL] Baffling sequential scan plan when index scan would

2005-04-20 Thread Chris Smith
Hi Jeff, Maybe because the key is a bigint - you're looking for an int (int4). Try casting it to a bigint ? Jeffrey W. Baker wrote: I always thought I would not be the kind of person who writes to this list asking why the planner is using a sequential scan. I always looked upon such people as newc

Re: [GENERAL] Baffling sequential scan plan when index scan would

2005-04-20 Thread Stephan Szabo
On Wed, 20 Apr 2005, Jeffrey W. Baker wrote: > I always thought I would not be the kind of person who writes to this > list asking why the planner is using a sequential scan. I always looked > upon such people as newcomers who would eventually learn the mysterious > wonders of the Pg query execu

[GENERAL] Baffling sequential scan plan when index scan would be best

2005-04-20 Thread Jeffrey W. Baker
I always thought I would not be the kind of person who writes to this list asking why the planner is using a sequential scan. I always looked upon such people as newcomers who would eventually learn the mysterious wonders of the Pg query execution planner. But really, this plan is bizarre! Why