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

Reply via email to