Episode 126 BRIN Pitfalls | pg_stat_statement Troubleshooting | Natural Join | Geography Type

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