Re: Seq scan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: stas-pgsql(at)xstas(dot)net, pgsql-general(at)postgresql(dot)org
Subject: Re: Seq scan
Date: 2002-08-16 17:05:03
Message-ID: 8931.1029517503@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> On Fri, 16 Aug 2002 stas-pgsql(at)xstas(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-08-16 17:20:32 Re: Seq scan
Previous Message omid omoomi 2002-08-16 16:43:15 Re: last entry