Re: psql performance

What is the query?
What is the schema for the tables in the query?
What is the cardinality of the tables?

What does the planner say, when you do this:
explain <query>
explain analyze <query>

http://www.faqs.org/docs/ppbook/r26943.htm

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Joseph
Shraibman
Sent: Thursday, April 14, 2005 6:19 PM
To: pgsql-general
Subject: [GENERAL] psql performance

How come when I paste a large query into psql it starts off fast but
then slows to a crawl eating up cpu just echoing the query back to me?
I'm using psql 7.4.7

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly