Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tuG0r-006Vq6-RN for pgsql-general@arkaria.postgresql.org; Mon, 17 Mar 2025 19:20:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tuG0q-000W2a-KK for pgsql-general@arkaria.postgresql.org; Mon, 17 Mar 2025 19:20:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tuFy3-000PYD-1V for pgsql-general@lists.postgresql.org; Mon, 17 Mar 2025 19:17:43 +0000 Received: from mail-oi1-x233.google.com ([2607:f8b0:4864:20::233]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tuFxz-003QGt-14 for pgsql-general@postgresql.org; Mon, 17 Mar 2025 19:17:42 +0000 Received: by mail-oi1-x233.google.com with SMTP id 5614622812f47-3f422d6e3b0so1233347b6e.1 for ; Mon, 17 Mar 2025 12:17:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742239058; x=1742843858; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=KoMmcAE3q0rR+z2F4BSzEZP4jka7+/c1gYA/ZnfEQjs=; b=ZXzjw0YeDw/ZScn86BsSI6PlJxPsRUu+Hc2gmEdkU52EgdKwfvla3tTD0EZR60kqx5 B/YAIM3TQjutYzuJhu88OBuRPS8YP/HZwRpHxVswsWvyAKRh1OVGWdvuLreAPsKVGtwg uXmHT8p4XddkIDqRX/hUcvDIGmGk46VYs5G+1NLpdTcnGJ54L21wHAAuOYFqaGh8LYI6 mCJd5BUARvgb5Oj2iPUNd4PYhSR6YYXypQ6ZJ/nOY+1pZvKbs0vPgFpLY2eDFw233n7e xP9NLcHeBxIpzwhmC8A8XIFZL24NJnPcIkar/igNGUqRtP6VH9fQuy7LAdIFBfjBfIuT Ay5w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742239058; x=1742843858; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=KoMmcAE3q0rR+z2F4BSzEZP4jka7+/c1gYA/ZnfEQjs=; b=VaFqIl8hXX7KXVm35OVQfYxsTyv66rQUQX4fGcz4RezspOzJCxHtZ+ftOGq8RBKrdS MdSLXsvhiIQqE0SDFM+abb/+RJrTt3N3Jpma4k1UnQ340MS1j/CrAqbRjXXhKPVrEpND /SMES4KxdiJCRYfBcS6a28obQIRVnR2/MAWdvCFdSSxpOXZHdHBDVIyMAw2cgxbc88zH FLQG6BKTYiSs34eaSr/BL4US8uasv9spuyQ3lePVJsI7mUQ1CWSswnN1o9zsuIWT62aq QOH29v/zkqFdsKKaPJp3iWM0LqyW0c7SDQ43TjUm8FvWeFoqEoLwWVT56pGazIfsOag2 vTPQ== X-Gm-Message-State: AOJu0Yw2tMk2ukgMfUIuitR9U29EaOXK1UiMF4qGf6+DQj1u70PWfSV9 Batro9lNRWDoPSo3XYnG4Yq1eKu6FXtxF793OM+TtlSN0irkQwMKzONSIdeOvNwu3IPavOS4/JW wQULPG8EwNCeQqaF94R4SqbRJ5EyZYg== X-Gm-Gg: ASbGncu4v8KUXJ9u8KQGebnRC0+ewmK8bqyx4tm/PHyvnPhPXXKMofl7odP4irq/hlg Yx9F0m8eo76Q+02TkXiSRZG3syKIZBo+cGRipGrBSG81j7xl4h6nAzlVsKp0hV3XlRNBLn4CtSE yjJxt0ZCUKqcDWn4BhrRAS4+T98rd1sdBfsVU1QNfRWQkTBTqkLSN+lx2u/snV0Wbsei5txsE= X-Google-Smtp-Source: AGHT+IHUeoBi57jH+7Tk0V0m92uudV7pUCxZDU/euopY25cYSqiO6VqEsy9MmEsPOmDWB03ayhwhb3G+Vsmd4mCz1h8= X-Received: by 2002:a05:6808:1a07:b0:3f7:8c9a:98d9 with SMTP id 5614622812f47-3fea18db2e4mr558828b6e.37.1742239058322; Mon, 17 Mar 2025 12:17:38 -0700 (PDT) MIME-Version: 1.0 References: <0558ddd4d71641bdb41fa49b2425f73c@safrangroup.com> <1061066336.5835157.1733316137292@mail.yahoo.com> <1482982714.8486017.1735661703839@mail.yahoo.com> <1763130721.4001842.1737733841628@mail.yahoo.com> <132487461.4068668.1737741687606@mail.yahoo.com> <0dc06cb7-33cc-43ba-a95f-535fdf0a0439@aklaver.com> <1751608443.5432365.1738081421269@mail.yahoo.com> <74599d1d-c8a2-4e59-a50d-019dcc973de8@aklaver.com> <200665967.5560583.1738095230696@mail.yahoo.com> <21b5d62a-19d1-413f-9d5e-d681cd2bb91b@aklaver.com> <47454513.6047834.1738179914107@mail.yahoo.com> <1841861276.9581730.1738888679871@mail.yahoo.com> <56243553.9616888.1738893835649@mail.yahoo.com> <940531722.732202.1739711614045@mail.yahoo.com> <6f44101c-ce01-478e-9fb1-138a10f358d9@aklaver.com> <688728245.763369.1739723234892@mail.yahoo.com> <1530912903.785341.1739727814631@mail.yahoo.com> <1995396392.4440995.1740508041256@mail.yahoo.com> <849879720.83739.1741119882239@mail.yahoo.com> <1375196293.189685.1741135860498@mail.yahoo.com> <2069355843.4441930.1742055484282@mail.yahoo.com> <1725462617.5114469.1742238742907@mail.yahoo.com> In-Reply-To: <1725462617.5114469.1742238742907@mail.yahoo.com> From: Ron Johnson Date: Mon, 17 Mar 2025 15:17:26 -0400 X-Gm-Features: AQ5f1JqjB1zOHyN4hLrMUdtsuDmo0V1IAhdSI0cLOr5dpSgJq5AsWuaxVIuXZek Message-ID: Subject: Re: #1 - Known bug (memory related) with respect to Aurora postgresql 13.16.3 To: pgsql-general Content-Type: multipart/alternative; boundary="0000000000002f6e0806308ea407" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000002f6e0806308ea407 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Aurora is very nonstandard. Thus, "we" don't support it. Having said that... "report running out of memory" smells like work_mem is set too high. On Mon, Mar 17, 2025 at 3:12=E2=80=AFPM Bharani SV-forum wrote: > Team > Any one faced similar issue with Ver 13.16.X > > > > ----- Forwarded Message ----- > *From:* Bharani SV-forum > *To:* pgsql-general@postgresql.org > *Cc:* Bharani SV esteembsv-forum > *Sent:* Saturday, March 15, 2025 at 12:18:04 PM EDT > *Subject:* Known bug (memory related) with respect to Aurora postgresql > 13.16.3 > > Team > We have Aurora postgresql ver (AWS- RDS) ver 13.16.3 and we faced issued > with an report process (batch process) running out of memory. > > regarding url " https://www.postgresql.org/docs/release/13.18/" > and url : > https://docs.aws.amazon.com/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes= /AuroraPostgreSQL.Updates.html#aurorapostgresql-versions-version1318x > > i am aware of > a) > Critical stability enhancements for 13.18 > > - > > Fixed an issue that in rare cases can cause CPU usage spike > > > Will be implementing RDS based Aurora Postgresql ver 13.18 patch fixes by > next week. > > Any one had noticed or have experienced w.r.to memory process w.r.to RDS- > aurora postgresql 13.16.3 ? > > Regards > > --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --0000000000002f6e0806308ea407 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Aurora is very nonstandard.=C2=A0 Thus, "we"= ; don't support it.

Having said that... "= report running out of memory" smells like work_mem is set too high.

On Mon, Mar 17, 2025 at 3:12=E2=80=AFPM = Bharani SV-forum <esteembsv= -forum@yahoo.com> wrote:
Team
Any one faced similar i= ssue with Ver 13.16.X


=

=20
----- Forwarded Message -----
From: Bharani SV-forum <esteembsv-forum@yahoo.com>= ;
Cc: Bharani SV esteembsv-forum <esteembsv-forum@yahoo.com&= gt;
Sent: Saturday, March 15, 2025 at 12:18:04 PM EDT
Subject: Known bug (memory related) with respect to Aurora pos= tgresql 13.16.3

=20 =20
Team
We have=C2=A0=C2= =A0Aurora postgresql ver (AWS- RDS) ver 13.16.3 and we faced issued with an= report process (batch process) running out of memory.


i am aware of
a)=C2=A0
Cr= itical stability enhancements for 13.18

  • Fixed an issue that in rare cases can cause CPU usa= ge spike

=C2=A0
Will be implementi= ng RDS based Aurora Postgresql ver 13.18 patch fixes by next week.
=C2=A0
Any one had noticed or have expe= rienced w.r.to memory proce= ss w.r.to RDS- aurora postg= resql 13.16.3 ?

Regards

=
=
<= div style=3D"font-family:"Helvetica Neue",Helvetica,Arial,sans-se= rif;font-size:13px;color:rgb(38,40,42)">

--
Death to <Redacted>, an= d butter sauce.
Don't boil me, I'm still alive.
&l= t;Redacted> lobster!
--0000000000002f6e0806308ea407--