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(at)quadratum-braccas(dot)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