"Michael J. Baars" <mjbaars1977.pgsql-hack...@cyberfiber.eu> writes:
> In the logfile you can see that the effective user data being written is only
> 913kb, while the actual being transmitted over the network is 7946kb when
> writing
> one row at a time. That is an overhead of 770%!
So ... don't write one row at a time.
You haven't shown any details, but I imagine that most of the overhead
comes from per-query stuff like the RowDescription metadata. The intended
usage pattern for bulk operations is that there's only one RowDescription
message for a whole lot of data rows. There might be reasons you want to
work a row at a time, but if your concern is to minimize network traffic,
don't do that.
regards, tom lane
