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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Joseph Shraibman Sent: Thursday, April 14, 2005 6:19 PM To: pgsql-general Subject: 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@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
