From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: gts.dmtr@gmail.com
Subject: BUG #18506: Memory Leak on wrong INNER JOINs
Date: Wed, 12 Jun 2024 13:51:30 +0000
Message-ID: <18506-750a4469a5a97fa4@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18506
Logged by: D Goutis
Email address: gts.dmtr@gmail.com
PostgreSQL version: 14.6
Operating system: Ubuntu Linux 22.04
Description:
Greetings,
I do not know the severity of this bug. I stumbled up due to a typo ( `a`
instead of `ag`).
In a series of multiple INNER JOINS, I referenced wrongly another table and
the postgres docker container bloated a 64GB RAM.
The commented out line is the fix.
I could submit more details.
Regards,
Dimitris
```
CREATE OR REPLACE VIEW exampledb.vw_project_summary AS
SELECT
p.project_id
, p.project_name
, ag.unique_values AS implementing_agencies
FROM exampledb.mt_project p
INNER JOIN exampledb.vw_action_types_per_project a
ON (p.project_id = a.project_id)
INNER JOIN exampledb.vw_agencies_per_project ag
ON (p.project_id = a.project_id);
-- ON (p.project_id = ag.project_id);
```
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-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, gts.dmtr@gmail.com
Subject: Re: BUG #18506: Memory Leak on wrong INNER JOINs
In-Reply-To: <18506-750a4469a5a97fa4@postgresql.org>
* 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