Re: [PATCH] Add enable_copy_program GUC to control COPY PROGRAM

On Fri, 5 Dec 2025, 12:32 Michael Banck, <mbanck(at)gmx(dot)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'.

>