Re: psql performance - Mailing list pgsql-general

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@postgresql.org
> > [mailto:pgsql-general-owner@postgresql.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@postgresql.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