Displaying episodes 1 - 30 of 39 in total
This week we're sharing an edited version of Nikolay's recent interview with Peter Zaitsev from Percona — they discuss MySQL vs Postgres, Percona’s success, open sourc...
psql vs GUIs
Nikolay and Michael discuss command line and graphical user interfaces for Postgres — what they are, some tips and tricks for learning, and what we each use and prefer...
Nikolay and Michael discuss major and minor version Postgres upgrades — what they are, how often they come out, and how regularly we should be upgrading. Here are link...
Nikolay and Michael discuss wait events — what they are, why we have them, and how to use them to help diagnose performance issues. Here are links to a few things we m...
Nikolay and Michael discuss TOAST (The Oversized-Attribute Storage Technique) — what it is, how it works, and some general things to be aware of. Here are links to a f...
Nikolay and Michael discuss JSON — our options for storing it in Postgres, whether or when we should, as well as a brief intro and some tips for JSON functions availab...
Nikolay and Michael discuss real-time analytics — what it means, what the options are, and some tips if you're trying to implement it within Postgres. Here are links t...
Nikolay and Michael discuss benchmarking — reasons to do it, and some approaches, tools, and resources that can help. Here are links to a few things we mentioned: Towa...
Nikolay and Michael discuss the default config — some tools and principles you can use to customise it, as well as several parameters you probably always want to chang...
Infra cost optimization
Nikolay and Michael discuss some options for reducing costs — from big-effort-big-reward items, to some smaller things that could also be very impactful.
Nikolay and Michael discuss auditing — why we might want it, what the options are, and even an idea for a future solution...
Copying a database
Nikolay and Michael discuss copying a database — what the various options are, how to copy large databases, and some pointers on performance.
Transaction ID wraparound
Nikolay and Michael discuss transaction ID wraparound — what it is, and some ideas to minimise the risk of it ever happening to you!
Postgres year in review 2022
Nikolay and Michael discuss some highlights from the Postgres ecosystem this year — including exciting startups, educational resources, sharding, and more.
Nikolay and Michael discuss planner row estimation — how it can cause performance issues, how to spot problems, and various options we have to fix them.
Nikolay takes Michael through the different replication options for Postgres — looking at different use cases, the options for each, and some things to be careful with.
Nikolay and Michael discuss timestamps and time math in Postgres — particularly around data type choice, functions available, and some things to watch out for.
Nikolay and Michael discuss PostgREST (and some similar projects) — what it is, as well as the pros and cons of using it.
Nikolay and Michael discuss materialized views — what they are, the pros/cons, and some areas they can improve (and hopefully will!)
Nikolay and Michael discuss Heap-Only Tuple (HOT) updates — what they are, the benefits, and things you can do to optimize for them.
Nikolay and Michael discuss database branching — how to define it, and the current state of tools and approaches.
Version control for databases
Nikolay and Michael discuss database schema version control — what we've seen, some options, and where we'd like to see improvements.
Contributing to Postgres
Nikolay and Michael discuss contributing to Postgres — whether to the code, or in other ways.
Nikolay and Michael discuss the age-old topic of implementing business logic on the database side versus the application side.
Nikolay and Michael discuss PostgreSQL 15 which was released yesterday! We go through our favourite features and some other ones that caught our eye.
102 Query optimization
Nikolay and Michael discuss the next step of query optimization work — the difficult topic of how to verify your changes won't make other things worse.
Why is Postgres popular?
Nikolay and Michael discuss why (and how) Postgres has been gaining popularity in recent years.
Nikolay and Michael discuss index maintenance — how do we know if or when we need it, and what we need to do.
Query macro analysis intro
Nikolay and Michael discuss query macro analysis — at the whole system level as opposed to an individual query.
WAL and checkpoint tuning
Nikolay talks Michael through a host of nuances about WAL and checkpoint tuning.