I see nothing which could suggest that the planner would perform better under PostgreSQL 14.
But even if the database could optimize such OR-ed queries with indexes, I can not see how converting the query into UNION
would degrade the performance. The database would style optimize the query by using the same indexes.
By the way here is a post explaining why using UNION is better for OR
clause with joins: https://www.cybertec-postgresql.com/en/avoid-or-for-better-performance/.
History | |||
---|---|---|---|
Date | User | Action | Args |
2021-08-13 22:59:48 | ced | set | messageid: <1628888388.7673469.ZO5IB6ISOCSQLVEV.issue10658@tryton.org> |
2021-08-13 22:59:48 | ced | set | recipients: + nicoe, albertca, reviewbot |
2021-08-13 22:59:48 | ced | link | issue10658 messages |
2021-08-13 22:59:48 | ced | create |
Showing 10 items. Show all history (warning: this could be VERY long)