Sbob <sbob@quadratum-braccas.com> writes:
> I have a client that is using a function to parse a set of rows from a
> table with a json column into table columns in a materialized view.
> ...
> The above approach is painfully slow, is there a better performing
> method of converting json strings to table columns?
json[b]_populate_record is meant for this sort of thing.
Also, if your source data is actually json not jsonb, that's
a seriously poor choice when you are in need of better
processing speed.
regards, tom lane