Re: PostgreSQL uses huge amount of memory

Parallel queries do exist in v11.
Rather trivial but I wonder if the OP has the same settings for
max_parallel_worker_per_gather and work_mem in both database versions.

Try setting max_parallel_workers_per_gather = 1 in v14 before running the
query. Is the memory usage kept in check with it?

El mié, 8 mar 2023 a la(s) 13:13, Scott Ribe (scott_ribe(at)elevated-dev(dot)com)
escribió:

> Could it be a difference in parallel queries? (I don't remember when those
> were added.) Certainly, a union is an example of something that will
> clearly get multiple workers.
>
> --
> Scott Ribe
> scott_ribe(at)elevated-dev(dot)com
> https://www.linkedin.com/in/scottribe/
>
>
>
> > On Mar 8, 2023, at 6:29 AM, Neimar Sierota <neimarsmo(at)gmail(dot)com> wrote:
> >
> > I did a test as you mentioned and in postgresql version 11 I didn't
> observe any change in memory consumption while the query is executed. With
> version 14, running the same query, it is possible to observe a
> considerable increase in memory usage during execution.
> > Could it be a bug in postgresql's memory management?
>
>
>
>