Postgres FM cover image

Row estimates

Postgres FM

00:00

Optimizing Row Estimates and Statistics Target in PostgreSQL

This chapter explores the impact of statistics target on query performance in PostgreSQL. It discusses the importance of a systematic approach and the need for more detailed statistics, particularly for columns with skewed distribution. The chapter also touches on major version upgrades, accuracy of row estimates, point in time recovery, and the ability to experiment with different query plans.

Transcript
Play full episode

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app