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@postgresql.org
[mailto:pgsql-general-owner@postgresql.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@postgresql.org so that your
message can get through to the mailing list cleanly