[GENERAL] PSQL command line print speed
От | Adrian Myers |
---|---|
Тема | [GENERAL] PSQL command line print speed |
Дата | |
Msg-id | CALAd6+0wXfBV6BWDiChz+BummvjTt0VSbjr_DMwCR=Vh4zsFEw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: [GENERAL] PSQL command line print speed
Re: [GENERAL] PSQL command line print speed Re: [GENERAL] PSQL command line print speed |
Список | 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
В списке pgsql-general по дате отправления: