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
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 |