Re: doc: alter table references bogus table-specific planner parameters
Simon Riggs <simon@2ndquadrant.com>
From: Simon Riggs <simon@2ndquadrant.com>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-01-06T04:33:46Z
Lists: pgsql-hackers, pgsql-performance
On Mon, 6 Jan 2020 at 04:13, Justin Pryzby <pryzby@telsasoft.com> wrote: > > > I agree with the sentiment of the third doc change, but your patch > removes > > the mention of n_distinct, which isn't appropriate. > > I think it's correct to remove n_distinct there, as it's documented > previously, > since e5550d5f. That's a per-attribute option (not storage) and can't be > specified there. > OK, then agreed. > The second change in your patch alters the meaning of the sentence in a > way > > that is counter to the first change. The name of these parameters is > > "Storage Parameters" (in various places); I might agree with describing > > them in text as "storage or planner parameters", but if you do that you > > can't then just refer to "storage parameters" later, because if you do it > > implies that planner parameters operate differently to storage > parameters, > > which they don't. > > The 2nd change is: > > for details on the available parameters. Note that the table > contents > - will not be modified immediately by this command; depending on the > + will not be modified immediately by setting its storage parameters; > depending on the > parameter you might need to rewrite the table to get the desired > effects. > > I deliberately qualified that as referring only to "storage params" rather > than > "this command", since planner params never "modify the table contents". > Possibly other instances in the document (and createtable) should be > changed > for consistency. > Yes, but it's not a correction, just a different preference of wording. -- Simon Riggs http://www.2ndQuadrant.com/ <http://www.2ndquadrant.com/> PostgreSQL Solutions for the Enterprise
Commits
-
Doc: Fix list of storage parameters available for ALTER TABLE
- b9a9cb1bfd6e 10.12 landed
- b9988facaec8 11.7 landed
- c4c76d198e3d 12.2 landed
- 6de7bcb76f65 13.0 landed
-
Enhance docs for ALTER TABLE lock levels of storage parms
- 6f3a13ff058f 10.0 cited
-
Reduce lock levels for table storage params related to planning
- 21d4e2e20656 10.0 cited
-
Reduce lock levels for ALTER TABLE SET autovacuum storage options
- 47167b7907a8 9.6.0 cited
-
Reduce lock levels of some ALTER TABLE cmds
- e5550d5fec66 9.4.0 cited
-
Reduce lock levels of CREATE TRIGGER and some ALTER TABLE, CREATE RULE actions.
- 2dbbda02e7e6 9.1.0 cited
-
Support ALTER TABLESPACE name SET/RESET ( tablespace_options ).
- d86d51a95810 9.0.0 cited