Re: New Copy Formats - avro/orc/parquet

From: Andres Freund <andres(at)anarazel(dot)de>
To: Nicolas Paris <niparisco(at)gmail(dot)com>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: New Copy Formats - avro/orc/parquet
Date: 2018-02-11 20:53:46
Message-ID: 20180211205345.47yvrxxodbfeyxk6@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2018-02-11 21:41:26 +0100, Nicolas Paris wrote:
> I have also the storage and network transfers overhead in mind:
> All those new formats are compressed; this is not true for current
> postgres BINARY format and obviously text based format. By experience,
> the binary format is 10 to 30% larger than the text one. On the
> contrary, an ORC file can be up to 10 times smaller than a text base
> format.

That seems largely irrelevant when arguing about using PROGRAM though,
right?

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nicolas Paris 2018-02-11 20:57:35 Re: New Copy Formats - avro/orc/parquet
Previous Message Nicolas Paris 2018-02-11 20:41:26 Re: New Copy Formats - avro/orc/parquet