5 phút Postgres E51: Sử dụng Memoize để tăng tốc các phép nối giữa hai bảng Postgres

Today, we're going to talk about how to use Memoize to speed up joins between two tables. We’re looking at presentations from Bruce Momjian and Lukas Eder.

*Find the article on our blog here:*

https://pganalyze.com/blog/5mins-postgres-16-pgbench-random-normal

*Learn more about pganalyze:*

https://pganalyze.com

https://pganalyze.com/newsletter

https://twitter.com/pganalyze/

*Check out the pganalyze library for eBooks, webinars, and more:*

https://pganalyze.com/resources

📑 *What we have discussed in this episode of 5mins of Postgres:*

*Beyond Joins and Indexes - by Bruce Mojian*

https://momjian.us/main/blogs/pgblog/2023.html#January_12_2023

*Beyond Joins and Indexes - Direct presentation PDF download*

https://momjian.us/main/writings/pgsql/beyond.pdf

*Explaining the Postgres Query Optimizer - by Bruce Momjian*

https://momjian.us/main/presentations/performance.html#optimizer

*Bruce Momjian on GitHub*

https://github.com/bmomjian

*PostgreSQL 14’s enable_memoize For Improved Performance of Nested Loop Joins - by Lukas Eder*

https://blog.jooq.org/postgresql-14s-enable_memoize-for-improved-performance-of-nested-loop-joins/

*Lukas Eder on Twitter*

https://twitter.com/lukaseder

*Postgres 14.4 Release notes*

https://www.postgresql.org//docs/14/release-14-4.html

*5mins of Postgres E45: IN lists vs ANY operator: Bind parameters and performance - with Lukas Eder*

https://pganalyze.com/blog/5mins-postgres-performance-in-lists-vs-any-operator-bind-parameters