public inbox for [email protected]  

help / color / mirror / Atom feed

From: sud <[email protected]>
To: Kashif Zeeshan <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Load a csv or a avro?
Date: Sun, 7 Jul 2024 01:32:33 +0530
Message-ID: <CAD=mzVUiYcg06iTaPaBEFa0utyu8vFCK5nEH0=fhM3eBjTZ9mQ@mail.gmail.com> (raw)
In-Reply-To: <CAAPsdhd=JfvVaNMnJ1eUAuBts3664Q0r8JE-OBijvEuTQO4P3w@mail.gmail.com>
References: <CAD=mzVUo9UpTw7F_8HKDK19ZmO6tE6Cfa4T-7i1J_QGfi6NpOw@mail.gmail.com>
	<CAAPsdhd=JfvVaNMnJ1eUAuBts3664Q0r8JE-OBijvEuTQO4P3w@mail.gmail.com>

On Fri, Jul 5, 2024 at 3:27 PM Kashif Zeeshan <[email protected]>
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?

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Load a csv or a avro?
  In-Reply-To: <CAD=mzVUiYcg06iTaPaBEFa0utyu8vFCK5nEH0=fhM3eBjTZ9mQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox