From: | Adrian Myers <hadrianmyers(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PSQL command line print speed |
Date: | 2017-05-17 16:46:15 |
Message-ID: | CALAd6+1A6n5+QNOHqe2e4P418nveU87k2sLEeNY=83pjafmXbA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ah I should have mentioned, the pager is off.
On Wed, May 17, 2017 at 12:34 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 05/17/2017 09:22 AM, Adrian Myers wrote:
>
> Please reply to list also
> Ccing list
>
> Hi Adrian, it is running locally.
>>
>
> In addition to Pavel's suggestions:
>
> In psql what does \pset show for the pager setting?
>
>
>
>
>> On Wed, May 17, 2017 at 12:21 PM, Adrian Klaver <
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>>
>> On 05/17/2017 09:03 AM, Adrian Myers wrote:
>>
>> Is there a way to speed up the actual line-by-line display of
>> the psql console in version 8.4?
>>
>> Queries which perform in a few milliseconds through a driver
>> (psycopg2 in this case) can take several seconds or minutes to
>> complete in the console, seemingly just due to it printing lines
>> at a very leisurely pace (in other words, this is not the delay
>> caused by the query itself, often it starts printing almost
>> instantly but spends a very long time just writing output).
>> While overall application performance is unaffected, simple
>> admin tasks and poking around the data take longer than I would
>> like as a result. Is there any way to improve just the
>> display/write performance in the console?
>>
>>
>> Is this a psql client local to the server machine or across a network?
>>
>>
>>
>> Thanks for any insight,
>> Adrian
>>
>>
>>
>> -- Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Olarte | 2017-05-17 16:55:41 | Re: PSQL command line print speed |
Previous Message | Adrian Klaver | 2017-05-17 16:34:45 | Re: PSQL command line print speed |