Re: Binary COPY IN size reduction - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Binary COPY IN size reduction
Date
Msg-id 20200428144115.GY13712@tamriel.snowman.net
Whole thread Raw
In response to Re: Binary COPY IN size reduction  (Lőrinc Pap <lorinc@gradle.com>)
List pgsql-hackers
Greetings,

* Lőrinc Pap (lorinc@gradle.com) wrote:
> Thanks for the quick response, Tom!

We prefer to not top-post on these lists, just fyi.

> What about implementing only the first part of my proposal, i.e. BINARY
> COPY without the redundant column count & size info?

For my part, at least, I like the idea- but I'd encourage thinking about
what we might do in a mixed-response situation too, as that's something
that's been discussed as at least desirable.  As long as we aren't
ending up painting ourselves into a corner somehow (which it doesn't
seem like we are, but I've not looked deeply at it) and we don't break
any existing clients, I'd generally be supportive of such an
improvement.  Constantly sending "this 4-byte int is 4 bytes long"
certainly does seem like a waste of bandwidth.

Thanks,

Stephen

Attachment

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: More efficient RI checks - take 2
Next
From: Tom Lane
Date:
Subject: Re: More efficient RI checks - take 2