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

From sud
Subject Re: Load a csv or a avro?
Date
Msg-id CAD=mzVUiYcg06iTaPaBEFa0utyu8vFCK5nEH0=fhM3eBjTZ9mQ@mail.gmail.com
Whole thread Raw
In response to Re: Load a csv or a avro?  (Kashif Zeeshan <kashi.zeeshan@gmail.com>)
List pgsql-general

On Fri, Jul 5, 2024 at 3:27 PM Kashif Zeeshan <kashi.zeeshan@gmail.com> wrote:
Hi

There are different data formats available, following are few points for there performance implications

1. CSV : It's easy to use and widely supported but it can be slower due to parsing overload.
2. Binary : Its faster to load but not human understandable.

Hope this helps.

Regards
Kashif Zeeshan


 My understanding was that it will be faster to load .csv as it is already being mapped to table rows and columns whereas in case of .avro the mapping has to be done so that the fields in the avro can be mapped to the columns in the table appropriately and that will be having additional overhead. Is my understanding correct?

pgsql-general by date:

Previous
From: Dennis White
Date:
Subject: Re: Can a long running procedure detect when smart shutdown is pending?
Next
From: sud
Date:
Subject: Re: Load a csv or a avro?