addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupsimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1outlookpersonJoin Group on CardStartprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

New Meetup: Statistics and Postgres - How the planner sees your data.

From: David F.
Sent on: Monday, August 3, 2009 10:26 PM
Announcing a new Meetup for The San Francisco Bay Area PostgreSQL Meetup Group!

What: Statistics and Postgres - How the planner sees your data.

When: September 8,[masked]:00 PM

Where: East Bay, likely at UC Berkeley

Nathan Boley presents:

Statistics and Postgres - How the planner sees your data.

Postgres relies heavily on statistics collected from data tables to
execute queries in the most efficient way possible. Despite the
relative 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 generate
and apply the summary statistics, and a theorem from probability
theory that is central to the planner's estimates. Finally, if time
permits, I will show how a custom selectivity function can
dramatically improve the planner accuracy for odd data distributions.
My hope is that a clear understanding of the process by which Postgres
collects and applies statistics will remove some of the black magic
from tuning Postgres and spur the development of better analysis

Learn more here:

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy