Foreign Key Indexes, Graph Queries, Linux Huge Pages, Text Column Size | Scaling Postgres 192
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/
Create your
podcast in
minutes
It is Free