Re: psql performance

[Paul Tillotson <pntil@xxxxxxxxxxx>]

I am not sure if this is relevant, but I think it may depend on what 
kind of shell you are using.  I use putty on windows XP, and it seemed 
to me that when I had the encoding set to Latin-1, it always pasted very 
fast, but when I had it set to UTF8, the paste would be slow.   I 
concluded (perhaps wrongly--I have not tested much) that putty goes much 
slower when using UTF8.

Have you confirmed that psql is at fault, and not your shell?  (I.e., 
try pasting directly to the shell--hopefully your query doesn't start 
with rm -rf /          : )

Regards,
Paul Tillotson

Joseph Shraibman wrote:

> 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 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