Thanks!
We are using jsonb
I'll have a look at
json[b]_populate_record
On 12/13/23 10:24, Tom Lane wrote:
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
