Re: psql performance

From: Paul Tillotson <pntil(at)shentel(dot)net>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql performance
Date: 2005-04-15 01:50:43
Message-ID: 425F1DF3.4050500@shentel.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Shraibman 2005-04-15 03:02:53 Re: psql performance
Previous Message Dann Corbit 2005-04-15 01:35:51 Re: psql performance