Re: Prepared statements and generic plans

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "Bruce Momjian *EXTERN*" <bruce(at)momjian(dot)us>
Cc: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Prepared statements and generic plans
Date: 2016-06-06 15:57:41
Message-ID: CAKFQuwZ_C3afvunBuaGuP41XsFExNgVPDxM8E_uwW39EP99LpQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jun 6, 2016 at 11:45 AM, Bruce Momjian *EXTERN* <bruce(at)momjian(dot)us>
wrote:

>
> One more thing --- there was talk of moving some of this into chapter
> 66, but as someone already mentioned, there are no subsections there
> because it is a dedicated topic:
>
> 66. How the Planner Uses Statistics.

> I am not inclined to add a prepare-only section to that chapter. On the
> other hand, the issues described apply to PREPARE and to protocol-level
> prepare, so having it in PREPARE also seems illogical. However, I am
> inclined to leave it in PREPARE until we are ready to move all of this
> to chapter 66.
>
>

​Actually, 66.1 exists ​- Row Estimation Examples

We should create 66.2 - e.g. Statistics of Parameterized Plans

My point was 66. How the Planner Uses Statistics doesn't have a table of
contents. I suspect it will if we add 66.2. But, should it have one now,
when the only section is 66.1?

The wording improvement are good; but my recommended split between the SQL
command section and 66.2 still applies.

David J.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-06-06 15:59:24 Re: New design for FK-based join selectivity estimation
Previous Message Tom Lane 2016-06-06 15:50:43 Re: Changed SRF in targetlist handling