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.
En esta página del sitio puede ver el video en línea Beginner tips | Postgres.FM 055 | de Duración hora minuto segunda en buena calidad , que subió el usuario PostgresTV 01 enero 1970, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,007 veces y le gustó 45 a los espectadores. Disfruta viendo!
