Search

Home > Scaling Postgres > Episode 192 Foreign Key Indexes | Graph Queries | Linux Huge Pages | Text Column Size
Podcast: Scaling Postgres
Episode:

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

Category: Technology
Duration: 00:12:40
Publish Date: 2021-11-23 00:02:24
Description:

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/

Total Play: 0