public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jean Baro <[email protected]>
To: [email protected]
Subject: Low priority batch insert
Date: Thu, 19 Oct 2017 14:10:12 -0200
Message-ID: <CA+fQeemNM8s9Y0_WKJ+rKStR9iePV3yfW+Rh6nhPUyGcJf3+hg@mail.gmail.com> (raw)
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

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

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Low priority batch insert
  In-Reply-To: <CA+fQeemNM8s9Y0_WKJ+rKStR9iePV3yfW+Rh6nhPUyGcJf3+hg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox