BUG #18506: Memory Leak on wrong INNER JOINs
От | PG Bug reporting form |
---|---|
Тема | BUG #18506: Memory Leak on wrong INNER JOINs |
Дата | |
Msg-id | 18506-750a4469a5a97fa4@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #18506: Memory Leak on wrong INNER JOINs
|
Список | pgsql-bugs |
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); ```
В списке pgsql-bugs по дате отправления: