Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA10703; Thu, 4 Mar 93 19:28:17 -0800
Message-Id: <9303050328.AA10703@postgres.Berkeley.EDU>
From: qiu@hardy.wpi.edu (Ke Qiu)
Subject: too slow ?
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: postgres@postgres.berkeley.edu
Date: Thu, 4 Mar 93 22:25:53 EST
X-Mailer: ELM [version 2.3 PL11]

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