From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Adrian Myers <hadrianmyers(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: PSQL command line print speed |
Date: | 2017-05-17 16:21:52 |
Message-ID: | 83928022-85b7-4469-160e-fff70a4d2ae8@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2017-05-17 16:34:45 | Re: PSQL command line print speed |
Previous Message | Adrian Klaver | 2017-05-17 16:19:58 | Re: EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2 |