You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Using batch from pgx doesn't write the data to the db in a batch write.
In effect it just piles all the inserts in a a big package (the "batch") and sends the big package in one go.
The db then commences to do all the inserts in one transaction but in sequence. If the sequence of inserts takes too much time, the connection will be severed and the fail ignored by pgx.
Batches are very limited in capacity for high volume use cases and need a better implementation.
The text was updated successfully, but these errors were encountered:
Using
batch
frompgx
doesn't write the data to the db in a batch write.In effect it just piles all the inserts in a a big package (the "batch") and sends the big package in one go.
The db then commences to do all the inserts in one transaction but in sequence. If the sequence of inserts takes too much time, the connection will be severed and the fail ignored by pgx.
Batches are very limited in capacity for high volume use cases and need a better implementation.
The text was updated successfully, but these errors were encountered: