Gregory Haase <haaseg@xxxxxxxxxxxxxxxx> writes: > The json_data column is not accounted for in pg_stats: Ah! I hadn't twigged to the fact that your bloat measurement approach assumed you had pg_stats entries for all the columns. > So I'm not sure if I'd actually qualify this as a "bug", but it appears > that there is no way to currently get stats on a json data type. ANALYZE currently punts on columns that don't have an equality operator, which json does not. There isn't that much in the way of stats that we could collect, though I suppose we could still compute average datum width and null fraction. I'm not sure whether there are plans to invent an equality operator for json. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
