5mins of Postgres E49: Speed up Postgres queries with UNIONs and subquery pull-up
Ғылым және технология
Today, we are looking at Postgres UNION vs. OR and are investigating if using UNION is always the better choice. Answer: It is not.
Find the article on our blog here:
pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
pganalyze.com
pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
pganalyze.com/resources
📑 What we have discussed in this episode of 5mins of Postgres:
UNION ALL, data types and performance - by Laurenz Albe
www.cybertec-postgresql.com/e...
Avoiding “OR” for better query performance - by Laurenz Albe
www.cybertec-postgresql.com/e...
Rewrite OR to UNION in PostgreSQL queries - by Laurenz Able
www.cybertec-postgresql.com/e...
Laurenz Able on GitHub
github.com/laurenz
Пікірлер: 3
Thanks for sharing such insightful content, rare on KZread.
Thank you for all the episodes and webinars!
Thank you for your work, Lukas and happy new year.