On Fri, Oct 20, 2017 at 1:10 AM, Jean Baro wrote:
> That's my first question in this mailing list! :)
Welcome!
> 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 runnin
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/up
nijam J wrote:
> our server is getting too slow again and again
Use "vmstat 1" and "iostat -mNx 1" to see if you are
running out of memory, CPU capacity or I/O bandwith.
Figure out if the slowness is due to slow queries or
an overloaded system.
Yours,
Laurenz Albe
--
Sent via pgsql-performanc
we are using cloud server
*this are memory info*
free -h
total used free sharedbuffers cached
Mem: 15G15G 197M 194M 121M14G
-/+ buffers/cache: 926M14G
Swap: 15G32M15G
*this are
