Re: v13: show extended stats target in \d
Alvaro Herrera <alvherre@2ndquadrant.com>
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: Georgios Kokolatos <gkokolatos@protonmail.com>, pgsql-hackers@lists.postgresql.org, Tomas Vondra <tomas.vondra@2ndquadrant.com>
Date: 2020-09-09T22:16:35Z
Lists: pgsql-hackers
On 2020-Sep-09, Justin Pryzby wrote: > As for the discussion about a separator, I think maybe a comma is enough. I > doubt anyone is going to think that you can get a valid command by prefixing > this by "CREATE STATISTICS". Actually, it didn't even occur to me it was valid > command without the stats target - after all, that's not true of indexes. > > + "public"."ab1_a_b_stats" (ndistinct, dependencies, mcv) ON a, b FROM ab1, STATISTICS 0 I vote to use a semicolon instead of comma, and otherwise +1. > This revision only shows the stats target in verbose mode (slash dee plus). I don't think this interferes enough with other stuff to relegate it to the "plus" version, since it's not shown if default. Tomas -- this needs to go in pg13, right? -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Commits
-
psql: Display stats target of extended statistics
- aeb781107a7c 13.0 landed
- 3c99230b4f0d 14.0 landed
-
Allow setting statistics target for extended statistics
- d06215d03b50 13.0 cited