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@xxxxxxxxxxx>> 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 Klaveradrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
