Fwd: Row description Metadata information

2021-02-15 Thread Aleksei Ivanov
and equal to 3.2, but type modifier in the row description is equal to -1, which is not correct. Does someone know where this modifier is calculated? Is this a bug or intention behavior? Best regards, Aleksei Ivanov

Re: Binary transfer vs Text transfer

2020-06-17 Thread Aleksei Ivanov
decrease that time? Best regards, On Wed, Jun 17, 2020 at 12:12 Andres Freund wrote: > 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 form

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

Question: Select messages using binary format

2020-03-06 Thread Aleksei Ivanov
Dear hackers, I know that it is possible to receive packets in binary format using declare binary cursor and than fetching the result. But is it possible just using ordinary select from simple query to specify that I want to receive the result in binary? Best regards,

Re: Proposal: PqSendBuffer removal

2020-03-06 Thread Aleksei Ivanov
not required a lot of changes. On Fri, Mar 6, 2020 at 10:45 Andres Freund wrote: > Hi, > > On March 5, 2020 1:23:21 PM PST, Aleksei Ivanov > wrote: > >Thank you for your reply! > > > >Yes, you are right there will be a separate call to send the data, but > >i

Re: Proposal: PqSendBuffer removal

2020-03-05 Thread Aleksei Ivanov
calls not more, if "len"is large enough. But I strongly doubt that a code path that netsout to more kernel calls will win.* Yes, internal_putbytes can be updated to send data directly if the length is more than internal buffer size. On Thu, Mar 5, 2020 at 15:04 Tom Lane wrote: > Ale

Re: Proposal: PqSendBuffer removal

2020-03-05 Thread Aleksei Ivanov
Thu, Mar 5, 2020 at 13:10 Tom Lane wrote: > Aleksei Ivanov writes: > > I am really curious what was the original intention of using the > > PqSendBuffer and is it possible to remove it now. > > > Currently all messages are copied from StringInfo to this buffer and > se

Proposal: PqSendBuffer removal

2020-03-05 Thread Aleksei Ivanov
Dear community, I am really curious what was the original intention of using the PqSendBuffer and is it possible to remove it now. Currently all messages are copied from StringInfo to this buffer and sent, which from my point of view is redundant operation. It is possible to directly send message