Re: How the planner uses statistics - Mailing list pgsql-docs

From Josh Berkus
Subject Re: How the planner uses statistics
Date
Msg-id 200502121522.10112.josh@agliodbs.com
Whole thread Raw
In response to Re: How the planner uses statistics  (Mark Kirkwood <markir@coretech.co.nz>)
Responses Re: How the planner uses statistics  (Michael Fuhr <mike@fuhr.org>)
Re: How the planner uses statistics  (Mark Kirkwood <markir@coretech.co.nz>)
List pgsql-docs
Mark,

> > I wanted to understand how the planner 'knows' how many rows are likely
> > to be emitted in a given stage of a query, and wrote down some examples
> > for my own benefit - I then wondered if this would be a good addition to
> > the 'Performance Tips' chapter. So... err here it is.
> >
> > Comments welcome.

Terrific.   I'd be happy to post this at www.powerpostgresql.org, if you want;
I think a lot of people would be interested.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Updated Russian translation of the FAQ
Next
From: Michael Fuhr
Date:
Subject: Re: How the planner uses statistics