PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15618
PG Version10.3
OSWindows 10
Opened2019-02-01 17:38:39+00
Reported bycd a
StatusOpen

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15618
Logged by:          cd a
Email address:      (redacted)
PostgreSQL version: 10.3
Operating system:   Windows 10
Description:        

Adding a unused join clause to the query, modifies the run time from 50ms to
4seconds.
No columns from the join clause are returned and the joined table is not
used in other places.
The join clause is a duplicate of another one that is used for further
joining.

The joined clause should have been automatically removed as it has no side
effects, thus using indices and optimizing query runtime.

Messages

DateAuthorSubject
2019-02-01 17:38:39+00PG Bug reporting formBUG #15618: Duplicating a join clause breaks index use
2019-02-01 18:25:06+00Pavel StehuleRe: BUG #15618: Duplicating a join clause breaks index use
2019-02-02 12:08:04+00AlexRe: BUG #15618: Duplicating a join clause breaks index use
2019-02-02 12:31:09+00Pantelis TheodosiouRe: BUG #15618: Duplicating a join clause breaks index use
2019-02-02 13:07:57+00AlexRe: BUG #15618: Duplicating a join clause breaks index use
2019-02-02 14:04:39+00AlexRe: BUG #15618: Duplicating a join clause breaks index use
2019-02-02 15:08:05+00Tom LaneRe: BUG #15618: Duplicating a join clause breaks index use
2019-02-02 15:53:30+00AlexRe: BUG #15618: Duplicating a join clause breaks index use