On Fri, 5 Dec 2025, 12:32 Michael Banck, <mbanck@gmx.net> wrote:
Hi,
On Wed, Dec 03, 2025 at 11:29:09PM +0500, Kirill Reshke wrote: > On Wed, 3 Dec 2025 at 23:17, I wrote: > > (I did derive the exact example > > when postgresql immediately restarts after some SQL but im 100% there > > is such thing ) > > select repeat('a',1024*1024*1023) from generate_series(1, 100);
I get
out of memory for query result
I guess it depends on whether you have memory overcommit on or off, and/or whether you run in a container/Kubernetes. Or maybe it depends on something else.
This denial of service is a different problem, and I agree that Postgres desperately needs a way to limit memory allocations per user (one can set work_mem as high as 1.999TB as regular user) and globally.
Michael
The idea here is that you get OOM which will lead to restart.
Aslo you can change archive command to 'shutdown'.
