Listen "Advanced psql"
Episode Synopsis
Nikolay and Michael discuss some cool things you can do with psql, the official CLI that ships with Postgres. Here are some links to things they mentioned:psql docs https://www.postgresql.org/docs/current/app-psql.html Our episode on psql vs GUIs https://postgres.fm/episodes/psql-vs-guispostgres_dba https://github.com/NikolayS/postgres_dbaOur episode on massive deletes https://postgres.fm/episodes/massive-deletesPostgres hacking session on \watch with limited number of loops https://www.youtube.com/watch?v=vTV8XhWf3mo pspg https://github.com/okbob/pspg Our episode on Postgres gotchas https://postgres.fm/episodes/postgres-gotchascurrent_setting() and set_config() docs https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SETpsql tips (site by Lætitia Avrot) https://psql-tips.org~~~What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!~~~Postgres FM is produced by:Michael Christofides, founder of pgMustardNikolay Samokhvalov, founder of Postgres.aiWith special thanks to:Jessie Draws for the elephant artwork
More episodes of the podcast Postgres FM
max_connections vs migrations
05/12/2025
What's new in EXPLAIN
21/11/2025
Tens of TB per hour
14/11/2025
Gapless sequences
31/10/2025
LWLocks
17/10/2025
User management
03/10/2025
Postgres 18
26/09/2025
Gadget's use of Postgres
19/09/2025
turbopuffer
12/09/2025
When not to use Postgres
05/09/2025
ZARZA We are Zarza, the prestigious firm behind major projects in information technology.