Statistics and Postgres--How the planner sees your data from how statistics and probability are related Watch Video
Preview(s):
Gallery
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
⏲ Duration: 60 min 90 sec ✓ Published: 14-Oct-2009
Description: Postgres relies heavily on statistics collected from data tables to execute queries in the most efficient way possible. Despite therelative simplicity of these statistics, the actual process by which they are collected and used to generate plans is a bit enigmatic. In the next 50 minutes, I will go through the assumptions that the planner makes about data access patterns, the heuristics that generateand apply the summary statistics, and a theorem from probability theory that is central to th
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)