Re: Prepared statements and generic plans - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Prepared statements and generic plans
Date
Msg-id CAKFQuwZ_C3afvunBuaGuP41XsFExNgVPDxM8E_uwW39EP99LpQ@mail.gmail.com
Whole thread Raw
In response to Re: Prepared statements and generic plans  ('Bruce Momjian *EXTERN*' <bruce@momjian.us>)
List pgsql-hackers
On Mon, Jun 6, 2016 at 11:45 AM, Bruce Momjian *EXTERN* <bruce@momjian.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.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Changed SRF in targetlist handling
Next
From: Tom Lane
Date:
Subject: Re: New design for FK-based join selectivity estimation