Scaling Postgres Episode 174 Lateral Joins | Generating JSON | dbcritic | Fetch First Rows

In this episode of Scaling Postgres, we discuss understanding lateral joins, generating JSON with Postgres, the dbcritic utility, and fetch first rows vs. limit.

Content Discussed

• Understanding LATERAL joins in PostgreSQL
• Cut Out the Middle Tier: Generating JSON Directly from Postgres
• dbcritic: Constructively criticizing your Postgres schema (using Idris)
• PostgreSQL: LIMIT vs FETCH FIRST ROWS … WITH TIES
• What happens to logical replication after running pg_upgrade?
• [YouTube] Secrets of 'psql'—a Great Tool!
• How much data goes into the WALs?
• Improved logging by libpq in PostgreSQL 14
• First contact with the pg_filedump
• Logical Replication Of In-Progress Transactions
• Jean-Christophe Arnu
• Rubber Duck Dev Show Episode 4 | Pair Programming - When, Why and How!