Re: [Fwd: Re: [DOCS] How the planner uses statistics]

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: [Fwd: Re: [DOCS] How the planner uses statistics]
Date: 2005-02-11 16:00:47
Message-ID: 11234.1108137647@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Mark Kirkwood <markir(at)coretech(dot)co(dot)nz> writes:
> Tom Lane wrote:
>> Hmmm ... it strikes me that someone wanting this level of detail
>> would be better advised to look into the source code.

> I did wonder about about it being better placed in 'internals'
> somewhere, but it seemed to follow on from the 'explain' and 'stats'
> sections quite well.

The internals section would be a good compromise. ISTM that in the
context of the "performance tips" chapter, all that people really want
to know is that the planner uses the pg_statistic entries to estimate
numbers of matching rows --- just how it goes about it is irrelevant
detail at that point.

regards, tom lane

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Marko Kreen 2005-02-11 16:55:12 Repost: FastFPE results for Linux/ARM
Previous Message Peter Eisentraut 2005-02-11 11:52:57 Re: Updated french translations