Best Practices | Postgres.FM 136 | #PostgreSQL #Postgres podcast

[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!] Nikolay and Michael use a recent "best practices" article as a prompt to discuss the topic — giving a few tips each on the topic areas mentioned, like schema design, performance, backups, and more. Here are some links to things they mentioned: * 7 Crucial PostgreSQL Best Practices (recent blog post) https://speakdatascience.com/postgresql-best-practices * Our “Don't do this” episode https://postgres.fm/episodes/dont-do-this * Article discussion on Hacker News https://news.ycombinator.com/item?id=42992913 * Mozilla’s SQL Style Guide https://docs.telemetry.mozilla.org/concepts/sql_style * Our “SQL vs NoSQL” episode with Franck Pachot https://postgres.fm/episodes/sql-vs-nosql * Our HA episode https://postgres.fm/episodes/high-availability ~~~ What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm https://twitter.com/PostgresFM, @samokhvalov https://twitter.com/samokhvalov and @michristofides https://twitter.com/michristofides ~~~ Postgres FM is produced by: - Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/ - Michael Christofides, founder of pgMustard https://pgmustard.com/ ~~~ This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.