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
Date: 2020-09-11T19:26:47Z
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 > > This revision only shows the stats target in verbose mode (slash dee plus). I put it back to show in non-verbose mode; after all it's only in the infrequent case that it's set to anything at all, and also it doesn't take up another column, as is the case with per-column stats targets. I changed the separator from comma to semicolon, because it seems a little less ambiguous. It's easy to change if people hate that. ... and pushed. Thanks. -- Á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