From: Michel SALAIS <msalais@msym.fr>
To: 'Wells Oliver' <wells.oliver@gmail.com>
Cc: 'John Scalia' <jayknowsunix@gmail.com>
Cc: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: 'pgsql-admin' <pgsql-admin@postgresql.org>
Subject: RE: Understanding was terminated by signal 9: Killed
Date: Wed, 27 Oct 2021 18:54:34 +0200
Message-ID: <015401d7cb53$52bd9800$f838c800$@msym.fr> (raw)
In-Reply-To: <CAOC+FBUZ-z38mr0tqqPRQEmjuNqyuYTdBACqrkUpEhNMZzH4=Q@mail.gmail.com>
References: <2009137.1634680908@sss.pgh.pa.us>
<AEEF347B-39EC-41FC-8AC9-2AFA54F71391@gmail.com>
<006701d7c5f0$e4ddc100$ae994300$@msym.fr>
<CAOC+FBUZ-z38mr0tqqPRQEmjuNqyuYTdBACqrkUpEhNMZzH4=Q@mail.gmail.com>
Hello,
I had an RDS instance with a “lot” of CPU and a “lot” of memory. I was studying tuning parameters for a particular application. I wanted to change instance type to have less CPU and less memory. There were no way to do it. The instance had to be erased an recreated. At the beginning, It was possible to choose an instance type with bigger RAM and more CPUs.
Regards
Michel SALAIS
Consultant Oracle, PostgreSQL
MSYM
23 rue du Départ
Boîte 37
75014 Paris
+33 6 68 94 19 60
<mailto:msalais@msym.fr> msalais@msym.fr
<http://www.msym.fr/; www.msym.fr
De : Wells Oliver <wells.oliver@gmail.com>
Envoyé : mercredi 20 octobre 2021 22:36
À : Michel SALAIS <msalais@msym.fr>
Cc : John Scalia <jayknowsunix@gmail.com>; Tom Lane <tgl@sss.pgh.pa.us>; pgsql-admin <pgsql-admin@postgresql.org>
Objet : Re: Understanding was terminated by signal 9: Killed
For posterity: RDS will definitely allow you to downgrade instance type.
On Wed, Oct 20, 2021 at 1:27 PM Michel SALAIS <msalais@msym.fr <mailto:msalais@msym.fr> > wrote:
Be careful!
I am not sure but upgrade for a larger instance can't be temporary. I think you can't downgrade to the original instance class thereafter...
--
Michel SALAIS
-----Message d'origine-----
De : John Scalia <jayknowsunix@gmail.com <mailto:jayknowsunix@gmail.com> >
Envoyé : mercredi 20 octobre 2021 01:12
À : Tom Lane <tgl@sss.pgh.pa.us <mailto:tgl@sss.pgh.pa.us> >
Cc : Wells Oliver <wells.oliver@gmail.com <mailto:wells.oliver@gmail.com> >; pgsql-admin <pgsql-admin@postgresql.org <mailto:pgsql-admin@postgresql.org> >
Objet : Re: Understanding was terminated by signal 9: Killed
You could always change the size of the RDS instance to something larger than what it currently is running, even just temporarily.
Sent from my iPad
> On Oct 19, 2021, at 6:01 PM, Tom Lane <tgl@sss.pgh.pa.us <mailto:tgl@sss.pgh.pa.us> > wrote:
>
> Wells Oliver <wells.oliver@gmail.com <mailto:wells.oliver@gmail.com> > writes:
>> In an RDS instance with 16GB RAM, I ran a long query which started by
>> setting temp_buffers to 16GB, so I think I plum ran out of memory,
>> but can anyone point me in a different direction if the following log
>> messages indicate something else is awry?
>
> Yeah, this:
>
>> 2021-10-19 21:10:37 UTC::@:[24752]:LOG: server process (PID 25813)
>> was terminated by signal 9: Killed
>
> almost certainly indicates the Linux OOM killer at work. If you were
> running your own system I'd point you to [1], but I doubt that RDS
> lets you put your hands on the relevant knobs.
>
> regards, tom lane
>
> [1]
> https://www.postgresql.org/docs/current/kernel-resources.html#LINUX-ME
> MORY-OVERCOMMIT
>
>
--
Wells Oliver
wells.oliver@gmail.com <mailto:wellsoliver@gmail.com>
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: pgsql-admin@postgresql.org
Cc: msalais@msym.fr, wells.oliver@gmail.com, jayknowsunix@gmail.com, tgl@sss.pgh.pa.us
Subject: RE: Understanding was terminated by signal 9: Killed
In-Reply-To: <015401d7cb53$52bd9800$f838c800$@msym.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox