Re: Seq scan

Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> On Fri, 16 Aug 2002 stas-pgsql@xstas.net wrote:
>> "SELECT my_field FROM my_table WHERE id=12168996"      takes
>> about half a minute ( 'id' is an sequential indexed field in my_table )
>>
>> EXPLAIN says it is doing a Seq Scan

> Have you vacuum analyzed the table?

I'm betting it's ye olde wrong-datatype issue.  What's the data type of
id?  If it's not int4 then a cast is indicated ...

            regards, tom lane