Postgres Pro
Downloads
Home   >   mailing lists

Re: Make COPY extendable in order to support Parquet and other formats - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Make COPY extendable in order to support Parquet and other formats
Date
Msg-id 20220624014500.tfbq5yewv73xmghl@alap3.anarazel.de
Whole thread Raw
In response to Re: Make COPY extendable in order to support Parquet and other formats  (Aleksander Alekseev <aleksander@timescale.com>)
Responses Re: Make COPY extendable in order to support Parquet and other formats
List pgsql-hackers
Tree view 
Hi,

On 2022-06-23 11:38:29 +0300, Aleksander Alekseev wrote:
> > I know little about parquet - can it support FROM STDIN efficiently?
> 
> Parquet is a compressed binary format with data grouped by columns
> [1]. I wouldn't assume that this is a primary use case for this
> particular format.

IMO decent COPY FROM / TO STDIN support is crucial, because otherwise you
can't do COPY from/to a client. Which would make the feature unusable for
anybody not superuser, including just about all users of hosted PG.

Greetings,

Andres Freund

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Race condition in TransactionIdIsInProgress
Next
From: Andres Freund
Date:
Subject: Re: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size