Episode 192 Foreign Key Indexes | Graph Queries | Linux Huge Pages | Text Column Size

<p>In this episode of Scaling Postgres, we discuss if foreign keys should have indexes, how to run graph queries, how to configure Linux huge pages and the benefits as well as text size similarities.</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://www.percona.com/blog/should-i-create-an-index-on-foreign-keys-in-postgresql/"> https://www.percona.com/blog/should-i-create-an-index-on-foreign-keys-in-postgresql/</a><br /> <br /> <a href= "https://www.youtube.com/watch?v=_RXfnnqsLlw">https://www.youtube.com/watch?v=_RXfnnqsLlw</a><br /> <br /> <a href= "https://www.enterprisedb.com/blog/improving-postgresql-performance-without-making-changes-postgresql"> https://www.enterprisedb.com/blog/improving-postgresql-performance-without-making-changes-postgresql</a><br /> <br /> <a href= "https://www.depesz.com/2021/11/19/does-varcharn-use-less-disk-space-than-varchar-or-text/"> https://www.depesz.com/2021/11/19/does-varcharn-use-less-disk-space-than-varchar-or-text/</a><br /> <br /> <a href= "https://pganalyze.com/blog/postgresql-views-django-python">https://pganalyze.com/blog/postgresql-views-django-python</a><br /> <a href= "https://www.enterprisedb.com/blog/pg-phriday-isolating-postgres-repmgr"> https://www.enterprisedb.com/blog/pg-phriday-isolating-postgres-repmgr</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/postgresql-on-wsl2-for-windows-install-and-setup/"> https://www.cybertec-postgresql.com/en/postgresql-on-wsl2-for-windows-install-and-setup/</a><br /> <br /> <a href= "https://www.depesz.com/2021/11/16/waiting-for-postgresql-15-allow-publishing-the-tables-of-schema/"> https://www.depesz.com/2021/11/16/waiting-for-postgresql-15-allow-publishing-the-tables-of-schema/</a><br /> <br /> <a href= "https://www.migops.com/blog/2021/11/15/postgresql-15-will-include-some-more-regexp-functions/"> https://www.migops.com/blog/2021/11/15/postgresql-15-will-include-some-more-regexp-functions/</a><br /> <br /> <a