The idea is:
While the workflow is running, n8n update the entire execution entity row at every node change.
In high throughput numbers, the size of the update process becomes very large.
Instead, I think just updating and normalizing the data column will greatly improve performance.
My use case:
We are trying to use n8n with high trough put with big workflows. In our system we are using n8n with seperate webhook and worker node with queue mode and postresql db.
I think it would be beneficial to add this because:
Normalising the data here will increase update speeds. It also increases the number of transactions that n8n can process by reducing the network costs between db-n8n.