pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18506: Memory Leak on wrong INNER JOINs
3+ messages / 3 participants
[nested] [flat]
* BUG #18506: Memory Leak on wrong INNER JOINs
@ 2024-06-12 13:51 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: PG Bug reporting form @ 2024-06-12 13:51 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: gts.dmtr@gmail.com
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);
```
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #18506: Memory Leak on wrong INNER JOINs
@ 2024-06-12 14:41 David G. Johnston <david.g.johnston@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: David G. Johnston @ 2024-06-12 14:41 UTC (permalink / raw)
To: gts.dmtr@gmail.com; pgsql-bugs@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #18506: Memory Leak on wrong INNER JOINs
@ 2024-06-12 15:09 GoutisD <gts.dmtr@gmail.com>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: GoutisD @ 2024-06-12 15:09 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org
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.
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-06-12 15:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-06-12 13:51 BUG #18506: Memory Leak on wrong INNER JOINs PG Bug reporting form <noreply@postgresql.org>
2024-06-12 14:41 ` David G. Johnston <david.g.johnston@gmail.com>
2024-06-12 15:09 ` GoutisD <gts.dmtr@gmail.com>
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