Re: Emitting JSON to file using COPY TO

From: Nathan Bossart <nathandbossart(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Joe Conway <mail(at)joeconway(dot)com>, Davin Shearer <davin(at)apache(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Emitting JSON to file using COPY TO
Date: 2023-12-06 16:44:39
Message-ID: 20231206164439.GC2873889@nathanxps13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Wed, Dec 06, 2023 at 10:33:49AM -0600, Nathan Bossart wrote:
> (format csv)
> Time: 12295.480 ms (00:12.295)
> Time: 12311.059 ms (00:12.311)
> Time: 12305.469 ms (00:12.305)
>
> (format json)
> Time: 24568.621 ms (00:24.569)
> Time: 23756.234 ms (00:23.756)
> Time: 24265.730 ms (00:24.266)

I should also note that the json output is 85% larger than the csv output.

--
Nathan Bossart
Amazon Web Services: https://aws.amazon.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message arun chirappurath 2023-12-06 17:41:20 Disable autocommit inside dbeaver
Previous Message Nathan Bossart 2023-12-06 16:33:49 Re: Emitting JSON to file using COPY TO

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2023-12-06 16:48:15 Re: Change GUC hashtable to use simplehash?
Previous Message Peter Geoghegan 2023-12-06 16:44:16 Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans)