Episode 170 Redis vs Postgres | Hard Quadrant | Optimizing Joins | Materialized Views

<p>In this episode of Scaling Postgres, we discuss Redis vs. Postgres, working in the hard quadrant, how Postgres optimizes joins and working with materialized views.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://spin.atomicobject.com/2021/02/04/redis-postgresql/">https://spin.atomicobject.com/2021/02/04/redis-postgresql/</a><br /> <br /> <a href= "https://momjian.us/main/blogs/pgblog/2021.html#June_16_2021">https://momjian.us/main/blogs/pgblog/2021.html#June_16_2021</a><br /> <br /> <a href= "https://www.youtube.com/watch?v=XA3SBgcZwtE">https://www.youtube.com/watch?v=XA3SBgcZwtE</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/creating-and-refreshing-materialized-views-in-postgresql/"> https://www.cybertec-postgresql.com/en/creating-and-refreshing-materialized-views-in-postgresql/</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/fun-with-pg_checksums">https://blog.crunchydata.com/blog/fun-with-pg_checksums</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/cross-join-in-postgresql/">https://www.cybertec-postgresql.com/en/cross-join-in-postgresql/</a><br /> <br /> <a href= "https://paquier.xyz/postgresql-2/postgres-14-monitoring-copy/">https://paquier.xyz/postgresql-2/postgres-14-monitoring-copy/</a><br /> <br /> <a href= "https://www.youtube.com/c/percona/videos">https://www.youtube.com/c/percona/videos</a><br /> <br /> <a href= "https://pgsqlpgpool.blogspot.com/2021/06/promoting-specied-node-in-pgpool-ii.html"> https://pgsqlpgpool.blogspot.com/2021/06/promoting-specied-node-in-pgpool-ii.html</a><br /> <br /> <a href= "https://blog.timescale.com/blog/how-and-why-to-become-a-postgresql-contributor/"> https://blog.timescale.com/blog/how-and-why-to-become-a-postgresql-contributor/</a><br /> <br /> <a href= "https://postgresql.life/post/josh_berkus/">https://postgresql.life/post/josh_berkus/</a><br /> <br /> <a href= "https://www.rubberduckdevshow.com/">https://www.ru