Don't see a problem pasting this one. Neither to a local nor to a remote ssh (running psql certainly). This is 7.4.7 on redhat and mandrake linux'es I'd suspect it has nothing to do with psql. Can you paste that into a normal ssh / terminal ? On Thursday 14 April 2005 20:05, Joseph Shraibman wrote: > It doesn't matter what the query is. The problem happens before it even > runs the query. Just try pasting select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' union select > 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'; > > ... and see how long it takes just to get to the point where it executes > the query. > > Incidentally when I did that I only got back one row. What's up with that? > > Dann Corbit wrote: > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- UC -- Open Source Solutions 4U, LLC 2570 Fleetwood Drive Phone: +1 650 872 2425 San Bruno, CA 94066 Cell: +1 650 302 2405 United States Fax: +1 650 872 2417 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
