Scaling Postgres

In this episode of Scaling Postgres, we discuss understanding lateral joins, generating JSON with Postgres, the dbcritic utility, and fetch first rows vs. limit. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/understanding-lateral-joins-in-postgresql/ https://blog.crunchydata.com/blog/generating-json-directly-from-postgres https://www.channable.com/tech/dbcritic-constructively-criticizing-your-postgres-schema https://www.cybertec-postgresql.com/en/postgresql-limit-vs-fetch-first-rows-with-ties/ https://elephanttamer.net/?p=58 https://www.youtube.com/watch?v=znPL6iDDou8 https://fluca1978.github.io/2021/07/13/PostgreSQLWalTraffic.html https://www.postgresql.fastware.com/blog/improved-logging-by-libpq-in-postgresql-14 https://www.highgo.ca/2021/07/14/first-contact-with-the-pg_filedump/ http://amitkapila16.blogspot.com/2021/07/logical-replication-of-in-progress.html https://postgresql.life/post