| From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
|---|---|
| To: | Adrian Myers <hadrianmyers(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PSQL command line print speed |
| Date: | 2017-05-17 16:55:41 |
| Message-ID: | CA+bJJbynHM9e2SHCjSHG3rLnPG-eJ=_B9Q2NjCKbJhDtzGePOQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Adrian:
On Wed, May 17, 2017 at 6:03 PM, Adrian Myers <hadrianmyers(at)gmail(dot)com> wrote:
> 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?
Are you sure the culprit is psql and not you terminal emulator ?
Francisco Olarte.-
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2017-05-17 18:37:49 | Re: database is not accepting commands |
| Previous Message | Adrian Myers | 2017-05-17 16:46:15 | Re: PSQL command line print speed |