Postgres and Parquet in the data lake

Re:Postgres and Parquet in the data lake by miohtama on Tuesday May 03, 2022 @06:45PM (#31254546)

Please correct if I am wrong but Parquet is columnar store whereas PSQL is row based?

[ Parent | on HN ]

Re:Postgres and Parquet in the data lake by pramsey on Wednesday May 04, 2022 @11:35AM (#31261950)

Parquet is a column-based file format. PostgreSQL is a SQL query engine, and the default storage is row-oriented, but the engine can do all kinds of fun things, hence the parquet_fdw extension and the cstore extension for example.

[ Parent | on HN ]

Re:Postgres and Parquet in the data lake by vladsanchez on Tuesday May 03, 2022 @07:41PM (#31255040)

Experimental: https://github.com/adjust/parquet_fdw/

[ Parent | on HN ]