From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Neimar Sierota <neimarsmo@gmail.com>
Cc: Mauricio Martini <martini.mauricio@hotmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL uses huge amount of memory
Date: Wed, 8 Mar 2023 09:13:13 -0700
Message-ID: <8A29F022-669D-4C40-B5D3-A2D1D0D727C2@elevated-dev.com> (raw)
In-Reply-To: <CAOX8E_Ro9U6Qvwj8XZHbsxsviuA73RJn_nxaT=yEq2di35MZnA@mail.gmail.com>
References: <MW5PR10MB57391E28809250993B92BB0782B49@MW5PR10MB5739.namprd10.prod.outlook.com>
<CAOX8E_Ro9U6Qvwj8XZHbsxsviuA73RJn_nxaT=yEq2di35MZnA@mail.gmail.com>
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@elevated-dev.com
https://www.linkedin.com/in/scottribe/> On Mar 8, 2023, at 6:29 AM, Neimar Sierota <neimarsmo@gmail.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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, neimarsmo@gmail.com, martini.mauricio@hotmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL uses huge amount of memory
In-Reply-To: <8A29F022-669D-4C40-B5D3-A2D1D0D727C2@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox