Row estimates

from Postgres FM · host Nikolay Samokhvalov and Michael Christofides

Here are links to a few things we mentioned: ANALYZE (docs)Autovacuum config (docs)Statistics used by the planner (docs) CREATE STATISTICS (docs) Row count estimates (pgMustard blog post) pg_hint_plan Optimizer methodology (talk by Robert Haas) Tomáš Vondra on statistics and hints (an excellent interview we forgot to mention, sorry!) ------------------------What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.If you would like to share this episode, here's a good link (and thank you!)Postgres FM is brought to you by:Nikolay Samokhvalov, founder of Postgres.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the amazing artwork

What this episode covers

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.

NOW PLAYING

Row estimates

0:00 31:51

1×

No transcript for this episode yet

We transcribe on demand. Request one and we'll notify you when it's ready — usually under 10 minutes.

Share this episode

Similar Episodes

November 30, 2025 - Unity through Service: A conversation with ACAO executive officer Hector Addison

Dec 12, 2025 ·23m

November 27, 2025 - A conversation with UOSU's President Jack Coen

Dec 4, 2025 ·32m

October 30, 2025 - AI: Yay or Nay?

Nov 8, 2025 ·36m

October 16, 2025 - Why are fewer young men enrolling in post-secondary education?

Oct 16, 2025 ·34m

October 2, 2025 - Chrystia Freeland resigns from cabinet and is appointed to new Ukraine envoy role

Oct 5, 2025 ·25m

September 18, 2025 - How Labubus took over your feed

Sep 18, 2025 ·26m

Similar Podcasts

Frag Big Moes Mama 98.8 KISS FM Big Moes Mama ist genauso crazy wie ihr Sohn und ab sofort part of the podcast family! Ab jetzt jeden Dienstag ab 22 Uhr auf KISS FM in der Podcast Happy Hour: Frag Big Moe’s Mama! Big Moe und seine Mama beantworten gemeinsam alle möglichen Fragen aus der KISS Nation. Jedes Thema ist willkommen. Natürlich nutzt Big Moe’s Mama jede Möglichkeit, um diverse peinliche Geschichten aus Big Moe’s Leben zu erzählen! Was für Big Moe auch mal sehr unangenehm werden kann. Tune in! Behind The X 102.5 KNIX (KNIX-FM) An all access pass to Arizona's #1 Country station. Hear the behind-the-scenes content and interviews from 102.5 KNIX! HealthCall LIVE WOWO / Federated Media HealthCall LIVE with Lee Kelso is a summary of the weeks most interesting and useful health and medical news. Lee Kelso is a veteran TV news anchor, radio journalist and host of viewer-driven, health-focused TV and online broadcasts. Each week, he brings you a series of interesting health news headlines and medical breakthroughs collected from professional journals and research projects around the world. You can also listen to HealthCall LIVE at 7am Tuesday mornings and 9-10am Saturday mornings on News/Talk 1190 WOWO 107.5 FM in Fort Wayne. The Math Factor C Goodman-Strauss Kyle Kellams A brief, weekly math conversation and puzzle, airing on KUAF 91.3 FM, Fayetteville Arkansas. Send your answers, comments, questions, puzzles, or cash, to [email protected]!

Frequently Asked Questions

How long is this episode of Postgres FM?

This episode is 31 minutes long.

When was this Postgres FM episode published?

This episode was published on December 23, 2022.

What is this episode about?

Is there a transcript available for this episode?

Yes, a full transcript is available for this episode. You can read the complete transcript on the episode page.

Can I download this Postgres FM episode?

Yes, you can download this episode by clicking the download button on the episode player, or subscribe to the podcast in your preferred podcast app for automatic downloads.

URL copied to clipboard!