On Mon, Oct 3, 2016 at 8:25 PM, Heikki Linnakangas <hlinn...@iki.fi> wrote: > Yeah. The idea was to use something like pg_node_tree to store all the > different kinds of statistics, the histogram, the MCV, and the functional > dependencies, in one datum. Or JSON, maybe. It sounds better than an opaque > bytea blob, although I'd prefer something more relational. For the > functional dependencies, I think we could get away with a simple float > array, so let's do that in the first cut, and revisit this for the MCV and > histogram later.
OK. A second thing was related to the use of schemas in the new system catalogs. As mentioned in [1], those could be removed. [1]: https://www.postgresql.org/message-id/cab7npqtu40q5_nsghvomjfbyh1hdtqmbfdj+kwfjspam35b...@mail.gmail.com. > Separate columns for the functional dependencies, the MCVs, > and the histogram, probably makes sense anyway. Probably.. -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
