Re: Performace question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lada 'Ray' Lostak" <ray(at)unreal64(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, "Sigi" <sieglt(at)unreal64(dot)net>
Subject: Re: Performace question
Date: 2003-10-29 17:19:51
Message-ID: 12710.1067447991@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Lada 'Ray' Lostak" <ray(at)unreal64(dot)net> writes:
> EXPLAIN SELECT
> id,parent,alias,aliasfull,name,comment,type,typeflags,flags,cluster,viewprio
> r FROM dtditems WHERE cluster IN (42)

> QUERY PLAN Seq Scan on dtditems (cost=0.00..253.40 rows=150 width=84)
> Filter: ("cluster" = 42)

Um ... what is the datatype of the "cluster" column? I'm betting it's
int8 or int2, not int4 which is what your constant is ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Åsmund Kveim Lie 2003-10-29 17:22:22 Cartesian product bug?
Previous Message Edwin Quijada 2003-10-29 17:06:50 Re: Error size varchar