Обсуждение: BUG #18506: Memory Leak on wrong INNER JOINs
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); ```
On Wed, Jun 12, 2024 at 7:25 AM PG Bug reporting form <noreply@postgresql.org> wrote:
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:
I do not know the severity of this bug.
Incorrectly written queries that cause super-large results that consume lots of memory are not evidence of bugs.
You are also reporting against a nearly two year old unsupported minor version and haven't provided a self-contained example; not particularly helpful.
David J.
You are correct in every aspect.
Given more time, I will try to replicate the issue, just in case it might lead to an actual bug ( or a safety net).
Thanks for your quick response.
Regards,
Dimitris
Στις Τετ 12 Ιουν 2024 στις 5:42 μ.μ., ο/η David G. Johnston <david.g.johnston@gmail.com> έγραψε:
On Wed, Jun 12, 2024 at 7:25 AM PG Bug reporting form <noreply@postgresql.org> wrote: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:
I do not know the severity of this bug.Incorrectly written queries that cause super-large results that consume lots of memory are not evidence of bugs.You are also reporting against a nearly two year old unsupported minor version and haven't provided a self-contained example; not particularly helpful.David J.