Postgres Pro
Downloads
Home   >   mailing lists

Re: Emitting JSON to file using COPY TO - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: Emitting JSON to file using COPY TO
Date
Msg-id 20231206164439.GC2873889@nathanxps13
Whole thread Raw
In response to Re: Emitting JSON to file using COPY TO  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: Emitting JSON to file using COPY TO
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans)
Next
From: Jeff Davis
Date:
Subject: Re: Change GUC hashtable to use simplehash?