Re: Load a csv or a avro? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Load a csv or a avro?
Date
Msg-id 11d5753c-578e-41a2-af17-6de956f03058@aklaver.com
Whole thread Raw
In response to Load a csv or a avro?  (sud <suds1434@gmail.com>)
Responses Re: Load a csv or a avro?
List pgsql-general
On 7/5/24 02:08, sud wrote:
> Hello all,
> 
> Its postgres database. We have option of getting files in csv and/or in 
> avro format messages from another system to load it into our postgres 
> database. The volume will be 300million messages per day across many 
> files in batches.

Are dumping the entire contents of each file or are you pulling a 
portion of the data out?

> 
> My question was, which format should we chose in regards to faster data 
> loading performance ? and if any other aspects to it also should be 
> considered apart from just loading performance?
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Removing the default grant of EXECUTE on functions/procedures to PUBLIC
Next
From: Matt Hughes
Date:
Subject: Planning of sub partitions