Hi there
We have a function which runs a set of update clauses and we are considering putting all the update clauses into one statement.
I would like to understand how postgres handles multiple updates. If we were to send 5 update statements in one sql statement to the db would it:
Do 5 passes on the table, on each pass, retrieve the id then update the row
Do 1 pass to retrieve the 5 primary keys, then update all rows in parallel
Apart from saving on the overhead of having to open up 5 separate connections, what are the benefits to passing in multiple updates in one statement?
Many thanks,
Jamie