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  Tip 1: tuples are physical versions of rows Related episodes: https://postgres.fm/episodes/how-to-become-a-dba and https://postgres.fm/episodes/hot-updates  Tip 2: always use EXPLAIN (ANALYZE, BUFFERS) Related episode: https://postgres.fm/episodes/buffers-by-default  Tip 3: throw away pgAdmin Related episode: https://postgres.fm/episodes/psql-vs-guis   Tip 4: enable as much logging as you can afford Related episode: https://postgres.fm/episodes/default-configuration  Tip 5: install pg_stat_statements Related episodes: https://postgres.fm/episodes/pg_stat_statements and https://postgres.fm/episodes/auto_explain, and https://postgres.fm/episodes/macro-query-analysis-intro Tip 6: run experiments on realistic data sets (use thin cloning and branching) Related episode: https://postgres.fm/episodes/database-branching  Tip 7: make sure data checksums are enabled  Related episode: https://postgres.fm/episodes/corruption   Tip 8: tune autovacuum to run frequently and move faster Related episode: https://postgres.fm/episodes/vacuum 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 Tip 10: indexes need to be rebuilt, unfortunately, since their health decline over time Related episode: https://postgres.fm/episodes/index-maintenance   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 via a YouTube comment, on social media, or by commenting on our Google doc! ~~~ Postgres FM is brought to you by: Nikolay Samokhvalov, founder of Postgres.ai Michael Christofides, founder of pgMustard With special thanks to: Jessie Draws for the amazing artwork