Postgres FM

Beginner tips


Listen Later

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 
...more
View all episodesView all episodes
Download on the App Store

Postgres FMBy Nikolay Samokhvalov and Michael Christofides

  • 4.7
  • 4.7
  • 4.7
  • 4.7
  • 4.7

4.7

21 ratings


More shows like Postgres FM

View all
Acquired by Ben Gilbert and David Rosenthal

Acquired

4,630 Listeners

Software Engineering Radio by se-radio@computer.org

Software Engineering Radio

271 Listeners

The Changelog: Software Development, Open Source by Changelog Media

The Changelog: Software Development, Open Source

289 Listeners

The a16z Show by Andreessen Horowitz

The a16z Show

1,084 Listeners

Software Engineering Daily by Software Engineering Daily

Software Engineering Daily

626 Listeners

Talk Python To Me by Michael Kennedy

Talk Python To Me

585 Listeners

Thoughtworks Technology Podcast by Thoughtworks

Thoughtworks Technology Podcast

43 Listeners

Python Bytes by Michael Kennedy and Brian Okken

Python Bytes

215 Listeners

Syntax - Tasty Web Development Treats by Wes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

Syntax - Tasty Web Development Treats

987 Listeners

CoRecursive: Coding Stories by Adam Gordon Bell - Software Developer

CoRecursive: Coding Stories

190 Listeners

Scaling Postgres by Creston Jamison

Scaling Postgres

12 Listeners

The Stack Overflow Podcast by The Stack Overflow Podcast

The Stack Overflow Podcast

64 Listeners

The Real Python Podcast by Real Python

The Real Python Podcast

142 Listeners

Oxide and Friends by Oxide Computer Company

Oxide and Friends

62 Listeners

The Pragmatic Engineer by Gergely Orosz

The Pragmatic Engineer

64 Listeners