Scaling Postgres

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. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://info.crunchydata.com/blog/avoiding-the-pitfalls-of-brin-indexes-in-postgres https://www.cybertec-postgresql.com/en/a-quick-pg_stat_statements-troubleshooting-hack/ https://blog.jooq.org/2020/08/05/use-natural-full-join-to-compare-two-tables-in-sql/ https://info.crunchydata.com/blog/postgis-and-the-geography-type https://www.2ndquadrant.com/en/blog/webinar-being-committed-a-review-of-transaction-control-statements-3-3-follow-up/ https://www.ongres.com/blog/a_generalized_unstructured_data_type_for_postgres/ https://supabase.io/blog/2020/08/02/continuous-postgresql-backup-walg/ https://www.2ndquadrant.com/en/blog/nss-on-windows-for-postgresql-development/ https://postgresql.life/post/tatsuo_ishii/