BUG #18506: Memory Leak on wrong INNER JOINs

Started by PG Bug reporting formalmost 2 years ago3 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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);

```

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: PG Bug reporting form (#1)
Re: BUG #18506: Memory Leak on wrong INNER JOINs

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.

#3GoutisD
gts.dmtr@gmail.com
In reply to: David G. Johnston (#2)
Re: BUG #18506: Memory Leak on wrong INNER JOINs

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> έγραψε:

Show quoted text

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.