{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Beginner tips","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/14c866c4\"></iframe>","width":"100%","height":180,"duration":2418,"description":"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! \n \nHere are some links to some things they mentioned:\nNikolay’s tweet with all 10 tips: https://twitter.com/samokhvalov/status/1679953049899642880 \nTip 1: tuples are physical versions of rows\nRelated episodes: https://postgres.fm/episodes/how-to-become-a-dba and https://postgres.fm/episodes/hot-updates \nTip 2: always use EXPLAIN (ANALYZE, BUFFERS)\nRelated episode: https://postgres.fm/episodes/buffers-by-default \nTip 3: throw away pgAdmin\nRelated episode: https://postgres.fm/episodes/psql-vs-guis  \nTip 4: enable as much logging as you can afford\nRelated episode: https://postgres.fm/episodes/default-configuration \nTip 5: install pg_stat_statements\nRelated episodes: https://postgres.fm/episodes/pg_stat_statements and https://postgres.fm/episodes/auto_explain, and https://postgres.fm/episodes/macro-query-analysis-intro\nTip 6: run experiments on realistic data sets (use thin cloning and branching)\nRelated episode: https://postgres.fm/episodes/database-branching \nTip 7: make sure data checksums are enabled \nRelated episode: https://postgres.fm/episodes/corruption  \nTip 8: tune autovacuum to run frequently and move faster\nRelated episode: https://postgres.fm/episodes/vacuum\nTip 9: query optimization will eventually be more important than configuration tuning\nRelated episodes: https://postgres.fm/episodes/intro-to-query-optimization and https://postgres.fm/episodes/102-query-optimization\nTip 10: indexes need to be rebuilt, unfortunately, since their health decline over time\nRelated episode: https://postgres.fm/episodes/index-maintenance  \nBonus tip: the official documentation, release notes, and source code comments/readmes are your friends! \n\n~~~\nWhat 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!\n\n~~~\nPostgres FM is...","thumbnail_url":"https://img.transistorcdn.com/NFbJlGhGV5mzIU1kM0iZ823A69pjZUNX40LszVO5LKI/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}