How the planner uses statistics

From: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>
To: pgsql-docs(at)postgresql(dot)org
Subject: How the planner uses statistics
Date: 2005-02-08 03:12:28
Message-ID: 42082E1C.8090408@coretech.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

best wishes

Mark

Attachment Content-Type Size
perform.sgml.diff text/plain 10.2 KB

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Rainer Brandt 2005-02-09 14:38:56 raise not in index
Previous Message John DeSoi 2005-02-05 15:06:59 Re: PostgreSQL 8.0.0 documentation for the MacOS X Help Viewer