Binary transfer vs Text transfer

Поиск
Список
Период
Сортировка
От Aleksei Ivanov
Тема Binary transfer vs Text transfer
Дата
Msg-id CAN0E21MgD18bNXr+05yHGVkdr8+EzziZ+dYUCWVhwdYe_Bc7LA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Binary transfer vs Text transfer  (Andres Freund <andres@anarazel.de>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Review for GetWALAvailability()
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Binary transfer vs Text transfer