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

  • @KunalKumar-kc1bw
    @KunalKumar-kc1bw Жыл бұрын

    Thanks for sharing such insightful content, rare on KZread.

  • @szuliq
    @szuliq Жыл бұрын

    Thank you for all the episodes and webinars!

  • @smyrnian_
    @smyrnian_ Жыл бұрын

    Thank you for your work, Lukas and happy new year.

Келесі