The cpu on the remote server is being used up by psql, and my shell is
local.
Paul Tillotson wrote:
> 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@postgresql.org 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@postgresql.org so that your
> message can get through to the mailing list cleanly