Hi there,
That's my first question in this mailing list! :)
Is it possible (node.js connecting to PG 9.6 on RDS) to set a lower priority to a connection so that that particular process (BATCH INSERT) would have a low impact on other running processes on PG, like live queries and single inserts/updates?
I would like the batch insert to complete as soon as possible, but at the same time keep individual queries and inserts running on maximum speed.
SINGLE SELECTS (HIGH PRIORITY)
SINGLE INSERTS/UPDATES (HIGH PRIORITY)
BATCH INSERT (LOW PRIORITY)
BATCH SELECT (LOW PRIORITY)
Is that a good idea? Is this feasible with Node.js + PG?
Thanks