In this episode of Scaling Postgres, we discuss 100x optimizations, how to audit table activity, designing schemas and how to set up table checksums. Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

• https://towardsdatascience.com/how-we-optimized-postgresql-queries-100x-ff52555eabe
• https://supabase.com/blog/2022/03/08/audit
• https://pganalyze.com/blog/5mins-postgres-auditing-pgaudit-supabase-supa-audit
• https://www.endpointdev.com/blog/2022/03/database-design-with-documents/
• https://www.cybertec-postgresql.com/en/postgresql-creating-checksums-for-tables/
• https://blog.crunchydata.com/blog/performance-and-spatial-joins
• https://blog.crunchydata.com/blog/cql-filtering-in-pg_featureserv
• https://postgrespro.com/blog/pgsql/5969296
• https://postgresql.life/post/ibrar_ahmed/
• https://www.rubberduckdevshow.com/episodes/33-reviewing-owasp-6-10/