Re: Performace question - Mailing list pgsql-general

From Tom Lane
Subject Re: Performace question
Date
Msg-id 12710.1067447991@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performace question  ("Lada 'Ray' Lostak" <ray@unreal64.net>)
List pgsql-general
"Lada 'Ray' Lostak" <ray@unreal64.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

pgsql-general by date:

Previous
From: "Edwin Quijada"
Date:
Subject: Re: Error size varchar
Next
From: Paulo Jan
Date:
Subject: Database design question: ugliness or referential integrity?