Beginner tips | Postgres.FM 055 | #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 discuss 10 beginner tips Nikolay recently shared — they go into a bit more detail on each, and even disagree a little on one or two! Here are some links to some things they mentioned: * Nikolay’s tweet with all 10 tips: https://twitter.com/samokhvalov/status/1679953049899642880 0:00 Introduction 3:21 Tip 1: tuples are physical versions of rows * Related episodes: https://postgres.fm/episodes/how-to-become-a-dba , https://postgres.fm/episodes/hot-updates 7:15 Tip 2: always use EXPLAIN (ANALYZE, BUFFERS) * Related episode: https://postgres.fm/episodes/buffers-by-default 10:36 Tip 3: throw away pgAdmin * Related episode: https://postgres.fm/episodes/psql-vs-guis 17:34 Tip 4: enable as much logging as you can afford * Related episode: https://postgres.fm/episodes/default-configuration 22:05 Tip 5: install pg_stat_statements * Related episodes: https://postgres.fm/episodes/pg_stat_statements, https://postgres.fm/episodes/auto_explain, and https://postgres.fm/episodes/macro-query-analysis-intro 25:04 Tip 6: run experiments on realistic data sets (use thin cloning and branching) * Related episode: https://postgres.fm/episodes/database-branching 29:48 Tip 7: make sure data checksums are enabled * Related episode: https://postgres.fm/episodes/corruption 34:17 Tip 8: tune autovacuum to run frequently and move faster * Related episode: https://postgres.fm/episodes/vacuum 37:01 Tip 9: query optimization will eventually be more important than configuration tuning * Related episodes: https://postgres.fm/episodes/intro-to-query-optimization and https://postgres.fm/episodes/102-query-optimization 39:20 Tip 10: indexes need to be rebuilt, unfortunately, since their health decline over time * Related episode: https://postgres.fm/episodes/index-maintenance 44:12 Bonus tip: the official documentation, release notes, and source code comments/readmes are your friends! ~~~ What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov https://twitter.com/samokhvalov and @michristofides https://twitter.com/michristofides ~~~ Postgres FM is brought to you by: - Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/ - Michael Christofides, founder of pgMustard https://pgmustard.com/ ~~~ This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.