Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mfmCK-0004QQ-RA for pgsql-admin@arkaria.postgresql.org; Wed, 27 Oct 2021 16:54:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mfmCJ-0004Lc-Pj for pgsql-admin@arkaria.postgresql.org; Wed, 27 Oct 2021 16:54:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mfmCJ-0004LS-Eo for pgsql-admin@lists.postgresql.org; Wed, 27 Oct 2021 16:54:43 +0000 Received: from mout.kundenserver.de ([212.227.126.131]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mfmCG-0004wB-Cp for pgsql-admin@postgresql.org; Wed, 27 Oct 2021 16:54:43 +0000 Received: from ANAT ([78.197.128.121]) by mrelayeu.kundenserver.de (mreue012 [212.227.15.168]) with ESMTPSA (Nemesis) id 1N8VkX-1mjsxY2GW1-014TUb; Wed, 27 Oct 2021 18:54:37 +0200 From: "Michel SALAIS" To: "'Wells Oliver'" Cc: "'John Scalia'" , "'Tom Lane'" , "'pgsql-admin'" References: <2009137.1634680908@sss.pgh.pa.us> <006701d7c5f0$e4ddc100$ae994300$@msym.fr> In-Reply-To: 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> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0155_01D7CB64.16497540" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQEGu34ySUp49ux2ICtowT1EXlcHWQGY4r0xAaX54v4CJvbY961d/9CA Content-Language: fr X-Provags-ID: V03:K1:RtJ0VFgdKYCz0cvJbFGIsxo7NHEyO6yawp51QZlo2sGP3a9+9Bf finsSYzXyA6VTwiieP2Wv4mny421ir4VusU4lodXgWwvxv3k8W1exi2X+lJKgq57rOvkmOW 1zuOO7eTPVXPHTwN0lTotbkl5MReZGbwuqjQbiHuaHu5HFR8MYo/5eaAy31sAe5/I15TI4E Yp7ZLuc4qOAQoyiwCMcsQ== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:rv7svAZo2mc=:fhwJKKc/2HAPmfvreC8t39 6JltwzRDYHtJOZz6ISTyMQwRo+nBy8bNOnwJnvR5BlhnhwjcML4sSSJ40tu63h2V825KeH4wA lrE3O2GlHQIouhZyrUpOiW0IIxMy+Vyiah7PP5rsir68E7WtCVXFzPOTyD3POEt4nvhJv/tEm MxY2Gr93i2xeFXoVnKEb3XuJsoxC1wCixCOSYokEoMWlMv5O3OzoIE1hwHvxHnROI+pdS7rbX g6lTsODlL0hesVn0gQCqY4OVYOZWSiEWjPMiRjH+ELlaYDFJD/0YPH4H3THLUKsLsbG4fNRDi Ic9biPRKct7INiFda8SEQAfKd8+/LcZT0NzrEkGfShkvG3qerW0jXYfmHP4+ukxHyKZVY7Nsk Ls1XDMxj9KSP4plv3SHn5isqGNqtBDm/Ai+u5gJNYydx+1DLwHnEG1P8JbyUB0ahGCL+gyTgr QQpeOqy+RB4WBI2/hyS77yEIVGPHyZNdby93WBRFp66Av/DPcFKzSxKo1BYn6N9aTGSv62nda 8L98FX8yDH0UzAcBtZBkPemlr/tsE/i1+4cZQGs8HRKTI7WmH0xK5KG9GIyQOlCV6uza/VybW vnoPPIzGarABUIVT2ya4KjsxkWB/IeHHDA8ykI8pKhcnvgVbJFcqI0I7EFpy/nQQQ3rS6ZHL8 FtYn9eM2FtEYrzuN6+EehX01wKudCgFwqUblwXY1RSJ8IhZiKfqoYDPLq0qvQveX/n1U= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_0155_01D7CB64.16497540 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hello, =20 I had an RDS instance with a =E2=80=9Clot=E2=80=9D of CPU and a = =E2=80=9Clot=E2=80=9D 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. =20 Regards =20 Michel SALAIS Consultant Oracle, PostgreSQL MSYM 23 rue du D=C3=A9part Bo=C3=AEte 37 75014 Paris =20 +33 6 68 94 19 60 msalais@msym.fr www.msym.fr =20 De : Wells Oliver =20 Envoy=C3=A9 : mercredi 20 octobre 2021 22:36 =C3=80 : Michel SALAIS Cc : John Scalia ; Tom Lane ; = pgsql-admin Objet : Re: Understanding was terminated by signal 9: Killed =20 For posterity: RDS will definitely allow you to downgrade instance type. =20 On Wed, Oct 20, 2021 at 1:27 PM Michel SALAIS > 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 = >=20 Envoy=C3=A9 : mercredi 20 octobre 2021 01:12 =C3=80 : Tom Lane > Cc : Wells Oliver >; pgsql-admin = > 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 > wrote: >=20 > =EF=BB=BFWells Oliver > 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,=20 >> but can anyone point me in a different direction if the following log = >> messages indicate something else is awry? >=20 > Yeah, this: >=20 >> 2021-10-19 21:10:37 UTC::@:[24752]:LOG: server process (PID 25813)=20 >> was terminated by signal 9: Killed >=20 > almost certainly indicates the Linux OOM killer at work. If you were=20 > running your own system I'd point you to [1], but I doubt that RDS=20 > lets you put your hands on the relevant knobs. >=20 > regards, tom lane >=20 > [1]=20 > https://www.postgresql.org/docs/current/kernel-resources.html#LINUX-ME > MORY-OVERCOMMIT >=20 >=20 =20 --=20 Wells Oliver wells.oliver@gmail.com =20 ------=_NextPart_000_0155_01D7CB64.16497540 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

Hello,

 

I had an RDS instance with a = =E2=80=9Clot=E2=80=9D of CPU and a =E2=80=9Clot=E2=80=9D 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=C3=A9part

Bo=C3=AEte = 37

75014 Paris

 

+33 6 68 94 19 = 60

msalais@msym.fr<= /p>

www.msym.fr

<= p class=3DMsoNormal> 

De : Wells Oliver = <wells.oliver@gmail.com>
Envoy=C3=A9 : mercredi 20 = octobre 2021 22:36
=C3=80 : 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> = 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>
Envoy=C3=A9 : = mercredi 20 octobre 2021 01:12
=C3=80 : Tom Lane <tgl@sss.pgh.pa.us>
Cc : Wells Oliver <wells.oliver@gmail.com>; pgsql-admin <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> wrote:
>
> = =EF=BB=BFWells Oliver <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-resource= s.html#LINUX-ME
> MORY-OVERCOMMIT
>
> =


 

-- =

------=_NextPart_000_0155_01D7CB64.16497540--