Ah I should have mentioned, the pager is off.
On Wed, May 17, 2017 at 12:34 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 05/17/2017 09:22 AM, Adrian Myers wrote:
Please reply to list also
Ccing list
Hi Adrian, it is running locally.
In addition to Pavel's suggestions:
In psql what does \pset show for the pager setting?
On Wed, May 17, 2017 at 12:21 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@aklaver.com >> wrote:
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.klaver@xxxxxxxxxxx <mailto:adrian.klaver@aklaver.com >
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
