PSQL command line print speed

From: Adrian Myers <hadrianmyers(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PSQL command line print speed
Date: 2017-05-17 16:03:23
Message-ID: CALAd6+0wXfBV6BWDiChz+BummvjTt0VSbjr_DMwCR=Vh4zsFEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks for any insight,
Adrian

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2017-05-17 16:09:35 Re: PSQL command line print speed
Previous Message Sandeep Gupta 2017-05-17 15:42:52 Re: sorry, too many clients already error