
Scaling Postgres Episode 174 Lateral Joins | Generating JSON | dbcritic | Fetch First Rows
Get New Episodes Weekly!
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!