Re: psql \copy from sends a lot of packets

2021-07-14 Thread Heikki Linnakangas
On 13/07/2021 14:52, Aleksander Alekseev wrote: The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: tested, passed Documentation:tested, passed The patch w

Re: psql \copy from sends a lot of packets

2021-07-13 Thread Aleksander Alekseev
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: tested, passed Documentation:tested, passed The patch was marked as the one that needs review and doesn't

Re: psql \copy from sends a lot of packets

2021-02-06 Thread Tom Lane
Heikki Linnakangas writes: > I just noticed that if you load a file using psql: > it sends every line as a separate FE/BE protocol CopyData packet. > ... > I'll add this to the next commitfest. There's similar inefficiency in > the server side in COPY TO, but I'll leave that for another patch. T

psql \copy from sends a lot of packets

2021-02-06 Thread Heikki Linnakangas
Hi, I just noticed that if you load a file using psql: \copy from it sends every line as a separate FE/BE protocol CopyData packet. That's pretty wasteful if the lines are narrow. The overhead of each CopyData packet is 5 bytes. To demonstrate, I generated a simple test file with the stri