Binary transfer vs Text transfer - Mailing list pgsql-hackers

From Aleksei Ivanov
Subject Binary transfer vs Text transfer
Date
Msg-id CAN0E21MgD18bNXr+05yHGVkdr8+EzziZ+dYUCWVhwdYe_Bc7LA@mail.gmail.com
Whole thread Raw
Responses Re: Binary transfer vs Text transfer
List pgsql-hackers
Hello, colleagues,

I have one question related to my current measurements results.

I am fetching integers in text format like:

Select * from table limit 10000000. 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 is 480 MB, but the transfer time is 21.5 seconds?

So, I have one question could someone explain what can be the reason why the transferring time for binary data is higher?

Best regards,

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Review for GetWALAvailability()
Next
From: Andres Freund
Date:
Subject: Re: Binary transfer vs Text transfer