Transactions & tasks performance issues
Hello!
I'm using Node.js v16.13.2, massive v6.10.2, pg-promise v10.11.1, pg v8.7.1. I have around 120 tables and performance measurements show that I have issue with transactions. Each starting transaction clones full DB object which is huge. Please see attached file: almost 95% of CPU time is spent cloning DB object & 5% performing actual work. May be it's possible to change DB architecture to separate connection context so that full cloning does not happen all the time?