Message 69375

Author
ced
Date
2021-08-13.22:59:48
Message id
69375

Content

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:48cedsetmessageid: <1628888388.7673469.ZO5IB6ISOCSQLVEV.issue10658@tryton.org>
2021-08-13 22:59:48cedsetrecipients: + nicoe, albertca, reviewbot
2021-08-13 22:59:48cedlinkissue10658 messages
2021-08-13 22:59:48cedcreate

Showing 10 items. Show all history (warning: this could be VERY long)