Re: New Copy Formats - avro/orc/parquet - Mailing list pgsql-general

From Andres Freund
Subject Re: New Copy Formats - avro/orc/parquet
Date
Msg-id 20180211205345.47yvrxxodbfeyxk6@alap3.anarazel.de
Whole thread Raw
In response to Re: New Copy Formats - avro/orc/parquet  (Nicolas Paris <niparisco@gmail.com>)
Responses Re: New Copy Formats - avro/orc/parquet  (Nicolas Paris <niparisco@gmail.com>)
List 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


pgsql-general by date:

Previous
From: Nicolas Paris
Date:
Subject: Re: New Copy Formats - avro/orc/parquet
Next
From: Nicolas Paris
Date:
Subject: Re: New Copy Formats - avro/orc/parquet