Sbob <sbob@xxxxxxxxxxxxxxxxxxxxx> 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
