Re: json_to_recordset() and CTE performance

PostgreSQL 13.0. You’d have to be specific about the configs you’re looking for, I’m using Postgres.app (postgresapp.com ) and am uncertain if it’s distributed with non-default configs. But, a quick grep shows these items that are configured: max_wal_size = 1GB min_wal_

json_to_recordset() and CTE performance

Hello, I’ve written an sql function that takes a single JSON parameter, in this case an array of objects each with eight properties (example below.) This function uses json_to_recordset() in a CTE to insert three rows on two tables. It takes nearly 7 minutes to insert my dataset of 8935 records