pg_statistic_ext.staenabled might not be the best column name
David Rowley <david.rowley@2ndquadrant.com>
From: David Rowley <david.rowley@2ndquadrant.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>, Tomas Vondra <tomas.vondra@2ndquadrant.com>,
Alvaro Herrera <alvherre@2ndquadrant.com>
Date: 2017-04-12T13:36:43Z
Lists: pgsql-hackers
Attachments
- ext_stats_rename_staenabled.patch (application/octet-stream) patch
I'd been thinking that staenabled is not the most suitable column name for storing the types of statistics that are defined for the extended statistics. For me, this indicates that something can be disabled, but there's no syntax for that, and even if there was, if we were to enable/disable the kinds, we'd likely want to keep tabs on which kinds were originally defined, otherwise it's more of an ADD and DROP than an ENABLE/DISABLE. "stakind" seems like a better name. I'd have personally gone with "statype" but pg_statistic already thinks stakind is better. A patch which changes this is attached -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
Commits
-
Rename columns in new pg_statistic_ext catalog
- ee6922112e9b 10.0 landed