A free weekly show on how to scale your PostgreSQL relational database.Join over a thousand engineers keeping current on relevant Postgres content.
In this episode of Scaling Postgres, we discuss a patch that can plan joins 16 times faster, the best way to record text values, extensions via image volumes with CloudNativePG and using pg_partman vs rolling your own.
In this episode of Scaling Postgres, we discuss enhancements bringing more than five times faster aggregates and 64% faster counts, better performance through sampling and my course sale is ending.
In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres releases and why you should shard your database.
In this episode of Scaling Postgres, we discuss performance improvements related to skip scans, faster backup & restore, benefits of minimal indexes and more details about my upcoming course discount.
In this episode of Scaling Postgres, we discuss the issues of partition locking during planning, the problem of too much memory, the importance of a txvector column and an upcoming sale on my course.