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.
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/
Create your
podcast in
minutes
It is Free