Scaling Postgres Episode 199 Shaped Sample Data | Version Changes | Missed Bottlenecks | Indexes for Newbies

In this episode of Scaling Postgres, we discuss how to generate shaped sample data, track changes between Postgres versions, identify missed bottlenecks and use different index types.

Content Discussed

• How to shape sample data with PostgreSQL generate_series() and SQL
• Configuration changes across Pg versions
• Five Easy to Miss PostgreSQL Query Performance Bottlenecks
• Postgres Indexes for Newbies
• Waiting for PostgreSQL 15 – Introduce log_destination=jsonlog
• Surviving Without A Superuser - Part Two
• Why I enjoy PostgreSQL - Infrastructure Engineer's Perspective
• PostgreSQL bi-directional replication using pglogical
• Data Normalization in PostgreSQL
• Kuntal Ghosh
• Rubber Duck Dev Show Episode 26 | The DarK Side of Open Source

YouTube Video