Episode 206 100x Optimizations, Auditing, Document Schema Designs, Checksums

In this episode of Scaling Postgres, we discuss 100x optimizations, how to audit table activity, designing schemas and how to set up table checksums. <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "https://towardsdatascience.com/how-we-optimized-postgresql-queries-100x-ff52555eabe"> https://towardsdatascience.com/how-we-optimized-postgresql-queries-100x-ff52555eabe</a></li> <li><a href= "https://supabase.com/blog/2022/03/08/audit">https://supabase.com/blog/2022/03/08/audit</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-auditing-pgaudit-supabase-supa-audit"> https://pganalyze.com/blog/5mins-postgres-auditing-pgaudit-supabase-supa-audit</a></li> <li><a href= "https://www.endpointdev.com/blog/2022/03/database-design-with-documents/"> https://www.endpointdev.com/blog/2022/03/database-design-with-documents/</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/postgresql-creating-checksums-for-tables/"> https://www.cybertec-postgresql.com/en/postgresql-creating-checksums-for-tables/</a></li> <li><a href= "https://blog.crunchydata.com/blog/performance-and-spatial-joins">https://blog.crunchydata.com/blog/performance-and-spatial-joins</a></li> <li><a href= "https://blog.crunchydata.com/blog/cql-filtering-in-pg_featureserv"> https://blog.crunchydata.com/blog/cql-filtering-in-pg_featureserv</a></li> <li><a href= "https://postgrespro.com/blog/pgsql/5969296">https://postgrespro.com/blog/pgsql/5969296</a></li> <li><a href= "https://postgresql.life/post/ibrar_ahmed/">https://postgresql.life/post/ibrar_ahmed/</a></li> <li><a href= "https://www.rubberduckdevshow.com/episodes/33-reviewing-owasp-6-10/"> https://www.rubberduckdevshow.com/episodes/33-reviewing-owasp-6-10/</a></li> </ul> <p> </p>