Row estimates episode artwork

EPISODE · Dec 23, 2022 · 31 MIN

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 

Episode metadata supplied by the publisher feed · Published Dec 23, 2022

Embed this episode

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.

Distinct summary based on available episode metadata or transcript content.

NOW PLAYING

Row estimates

0:00 31:51

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.

No similar podcasts found.

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.

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. Use the download control on the episode player to save the publisher-provided media file.
URL copied to clipboard!