"Michael J. Baars" 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 s
On Wed, 2021-02-24 at 19:18 -0600, Justin Pryzby wrote:
> On Wed, Feb 24, 2021 at 09:14:19AM +0100, Michael J. Baars wrote:
> > I've written this function to insert several rows at once, and noticed a
> > certain postgresql overhead as you can see from the log file. A lot more
> > data than
> > t
On Wed, Feb 24, 2021 at 09:14:19AM +0100, Michael J. Baars wrote:
> I've written this function to insert several rows at once, and noticed a
> certain postgresql overhead as you can see from the log file. A lot more data
> than the
> user data is actually sent over the net. This has a certain not
