Beginner tips

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 …

databases postgres postgresql sql technology