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.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

https://www.percona.com/blog/should-i-create-an-index-on-foreign-keys-in-postgresql/ https://www.youtube.com/watch?v=_RXfnnqsLlw https://www.enterprisedb.com/blog/improving-postgresql-performance-without-making-changes-postgresql https://www.depesz.com/2021/11/19/does-varcharn-use-less-disk-space-than-varchar-or-text/ https://pganalyze.com/blog/postgresql-views-django-python https://www.enterprisedb.com/blog/pg-phriday-isolating-postgres-repmgr https://www.cybertec-postgresql.com/en/postgresql-on-wsl2-for-windows-install-and-setup/ https://www.depesz.com/2021/11/16/waiting-for-postgresql-15-allow-publishing-the-tables-of-schema/ https://www.migops.com/blog/2021/11/15/postgresql-15-will-include-some-more-regexp-functions/ https://stackgres.io/blog/easily-running-babelfish-for-postgresql-on-kubernetes/ https://postgresql.life/post/louise_grandjonc/ https://www.rubberduckdevshow.com/episodes/21-what-is-devops/