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.

Content Discussed

• Should I Create an Index on Foreign Keys in PostgreSQL?
• [YouTube] Webinar: Graph Queries with PostgreSQL
• Improving PostgreSQL performance without making changes to PostgreSQL
• Does varchar(n) use less disk space than varchar() or text?
• Using PostgreSQL Views in Django
• PG Phriday: Isolating Postgres with repmgr
• PostgreSQL on WSL2 for Windows: Install and setup
• Waiting for PostgreSQL 15 – Allow publishing the tables of schema.
• PostgreSQL 15 will include some more regexp functions
• Easily Running Babelfish for PostgreSQL on Kubernetes
• Louise Grandjonc
• Rubber Duck Dev Show Episode 21 | What is DevOps?

YouTube Video

Podcast Audio