Beginner tips | Postgres.FM 055 |
[ 🇬🇧_🇺🇸 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: / 1679953049899642880
0:00 Introduction
3:21 Tip 1: tuples are physical versions of rows
Related episodes: https://postgres.fm/episodes/how-to-b... , https://postgres.fm/episodes/hot-updates
7:15 Tip 2: always use EXPLAIN (ANALYZE, BUFFERS)
Related episode: https://postgres.fm/episodes/buffers-...
10:36 Tip 3: throw away pgAdmin
Related episode: https://postgres.fm/episodes/psql-vs-...
17:34 Tip 4: enable as much logging as you can afford
Related episode: https://postgres.fm/episodes/default-...
22:05 Tip 5: install pg_stat_statements
Related episodes: https://postgres.fm/episodes/pg_stat_..., https://postgres.fm/episodes/auto_exp..., and https://postgres.fm/episodes/macro-qu...
25:04 Tip 6: run experiments on realistic data sets (use thin cloning and branching)
Related episode: https://postgres.fm/episodes/database...
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... and https://postgres.fm/episodes/102-quer...
39:20 Tip 10: indexes need to be rebuilt, unfortunately, since their health decline over time
Related episode: https://postgres.fm/episodes/index-ma...
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 / samokhvalov and @michristofides / 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.
On this page of the site you can watch the video online Beginner tips | Postgres.FM 055 | with a duration of hours minute second in good quality, which was uploaded by the user PostgresTV 01 January 1970, share the link with friends and acquaintances, this video has already been watched 1,007 times on youtube and it was liked by 45 viewers. Enjoy your viewing!
