BRIN Pitfalls, pg_stat_statement Troubleshooting, Natural Join, Geography Type | Scaling Postgres 126

In this episode of Scaling Postgres, we discuss BRIN pitfalls, using pg_stat_statements for troubleshooting, natural joins to detect duplicates and the geography type.

Content Discussed

• Avoiding the Pitfalls of BRIN Indexes in Postgres
• A quick pg_stat_statements troubleshooting hack
• Use NATURAL FULL JOIN to compare two tables in SQL
• PostGIS and the Geography Type
• Webinar: Being Committed – A Review of Transaction Control Statements 3/3 [Follow Up]
• Beyond jsonb: a generalized, unstructured data type for Postgres
• Continuous PostgreSQL backups using WAL-G
• NSS on Windows for PostgreSQL development
• Tatsuo Ishii

YouTube Video

Podcast Audio