37 subscribers
התחל במצב לא מקוון עם האפליקציה Player FM !
Beginner tips
Manage episode 371851302 series 3369151
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
144 פרקים
Manage episode 371851302 series 3369151
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
144 פרקים
כל הפרקים
×ברוכים הבאים אל Player FM!
Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.