Subject: too slow ?

From: [email-masked] (Ke Qiu)
Date: Thu, 4 Mar 93 22:25:53 EST

Hi,

I used the following query to get the user defined attributes
and their types in class "emp". It took minutes to come up with
the results. What's wrong with this query? Is there any faster
way to to the same thing? 

( I tried the benchmark queries, it seems pretty fast. )

*******************************************************

retrieve (pg_attribute.attname, pg_type.typname)
  where  pg_class.relname = "emp"::char16 and
         pg_class.oid = pg_attribute.attrelid and
	 pg_attribute.attnum > 0 and
	 pg_attribute.atttypid = pg_type.oid 
\g

********************************************************

Ke Qiu
Computer Sciecne Dept.
Worcester Polytechnic Institute
Worcester, MA 01609