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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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
