Skip site navigation (1) Skip section navigation (2)

Re: How the planner uses statistics

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: How the planner uses statistics
Date: 2005-02-12 23:22:10
Message-ID: 200502121522.10112.josh@agliodbs.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-docs by date

Next:From: Michael FuhrDate: 2005-02-12 23:28:14
Subject: Re: How the planner uses statistics
Previous:From: Bruce MomjianDate: 2005-02-11 04:53:53
Subject: Re: Updated Russian translation of the FAQ

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group