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.
Nesta página do site você pode assistir ao vídeo on-line Beginner tips | Postgres.FM 055 | duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário PostgresTV 01 Janeiro 1970, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 1,007 vezes e gostou 45 espectadores. Boa visualização!
