Re: New Copy Formats - avro/orc/parquet

Поиск
Список
Период
Сортировка
От Nicolas Paris
Тема Re: New Copy Formats - avro/orc/parquet
Дата
Msg-id 20180211205735.nt6auxazit42qmcs@gmail.com
обсуждение исходный текст
Ответ на Re: New Copy Formats - avro/orc/parquet  (Andres Freund <andres@anarazel.de>)
Ответы Re: New Copy Formats - avro/orc/parquet  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Le 11 févr. 2018 à 21:53, Andres Freund écrivait :
> 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?
> 

Indeed those storage and network transfers are only considered versus
CSV/BINARY format. No link with PROGRAM aspect.


В списке pgsql-general по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: New Copy Formats - avro/orc/parquet
Следующее
От: Andres Freund
Дата:
Сообщение: Re: New Copy Formats - avro/orc/parquet