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
