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_

Re: json_to_recordset() and CTE performance

Version? What is the value for work_mem and other configs that are non-default? I see some estimates that are rather off like - -> Nested Loop (cost=0.26..4.76 rows=100 width=148) (actual time=183.906..388716.550 rows=8935 loops=1) Buffers: shared hit=53877 dirtied=