Re: Binary transfer vs Text transfer

2020-06-17 Thread Aleksei Ivanov
Hi, Thanks for the attached link, but I also noticed using iftop, that during fetching the data there is almost no delay using text transfer, while there is several seconds in delay before data is starting fetching using binary transfer. Could you suggest where can I have a look to resolve it or d

Re: Binary transfer vs Text transfer

2020-06-17 Thread Andres Freund
Hi, On 2020-06-17 11:55:44 -0700, Aleksei Ivanov wrote: > I have one question related to my current measurements results. > > I am fetching integers in text format like: > > Select * from table limit 1000. It take 18.5 seconds to finish and the > transfer data is 633 MB. > > When I fetchin

Binary transfer vs Text transfer

2020-06-17 Thread Aleksei Ivanov
Hello, colleagues, I have one question related to my current measurements results. I am fetching integers in text format like: Select * from table limit 1000. It take 18.5 seconds to finish and the transfer data is 633 MB. When I fetching the same data using binary cursor, the transfer data