Performance of INSERT ON CONFLICT UPDATE query when update part has a large number of CASE WHEN conditions
I need to upsert data to a PostgreSQL database from a high traffic application which needs to be optimized for write performance. The different rows to upsert in a batch will have values for different columns. They are not full updates of all columns. And these would be upserts so the rows would need to be inserted or updated.
Performance of INSERT ON CONFLICT UPDATE query when update part has a large number of CASE WHEN conditions
I need to upsert data to a PostgreSQL database from a high traffic application which needs to be optimized for write performance. The different rows to upsert in a batch will have values for different columns. They are not full updates of all columns. And these would be upserts so the rows would need to be inserted or updated.
Performance long INSERT ON CONFLICT UPDATE query when update part has a large number of CASE WHEN conditions
I need to upsert data to a PostgreSQL database from a high traffic application which needs to be optimized for write performance. The different rows to upsert in a batch will have values for different columns. They are not full updates of all columns. And these would be upserts so the rows would need to be inserted or updated.