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