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@xxxxxxxxxxxxxxxx) 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@xxxxxxxxxxxxxxxx
https://www.linkedin.com/in/scottribe/
> On Mar 8, 2023, at 6:29 AM, Neimar Sierota <neimarsmo@xxxxxxxxx> 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?
