Re: [GENERAL] PSQL command line print speed

2017-05-18 Thread Francisco Olarte
Adrian: On Wed, May 17, 2017 at 8:40 PM, Adrian Klaver wrote: > On 05/17/2017 09:46 AM, Adrian Myers wrote: >> Ah I should have mentioned, the pager is off. > Is that by choice and if so why? > > With the pager off you have to wait for the entire output to write to the

Re: [GENERAL] PSQL command line print speed

2017-05-18 Thread Francisco Olarte
CCing the list. Adrian: On Wed, May 17, 2017 at 6:58 PM, Adrian Myers wrote: > That is a great question, and no, I'm not. This is on Windows and I see this > with normal cmd.exe and ConEmu but I have been using ConEmu for some time > and have not looked into settings

Re: [GENERAL] PSQL command line print speed

2017-05-17 Thread Adrian Klaver
On 05/17/2017 09:46 AM, Adrian Myers wrote: Ah I should have mentioned, the pager is off. Is that by choice and if so why? With the pager off you have to wait for the entire output to write to the screen. For anything but a small dataset that is going to take time. -- Adrian Klaver

Re: [GENERAL] PSQL command line print speed

2017-05-17 Thread Francisco Olarte
Adrian: On Wed, May 17, 2017 at 6:03 PM, Adrian Myers 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

Re: [GENERAL] PSQL command line print speed

2017-05-17 Thread Adrian Myers
Ah I should have mentioned, the pager is off. On Wed, May 17, 2017 at 12:34 PM, Adrian Klaver 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

Re: [GENERAL] PSQL command line print speed

2017-05-17 Thread Adrian Klaver
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

Re: [GENERAL] PSQL command line print speed

2017-05-17 Thread Adrian Klaver
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,

Re: [GENERAL] PSQL command line print speed

2017-05-17 Thread Pavel Stehule
Hi 2017-05-17 18:03 GMT+02:00 Adrian Myers : > 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

[GENERAL] PSQL command line print speed

2017-05-17 Thread Adrian Myers
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