Re: psql performance

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(at)postgresql(dot)org
> > [mailto:pgsql-general-owner(at)postgresql(dot)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(at)postgresql(dot)org 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