pg_parquet

Overview

PIGSTY 3rd Party Extension: pg_parquet : copy data between Postgres and Parquet

Information

• Extension ID: 2460
• Extension Name: pg_parquet
• Package Name: pg_parquet
• Category: OLAP
• License: PostgreSQL
• Website: https://github.com/CrunchyData/pg_parquet/
• Language: Rust
• Extra Tags: pgrx
• Comment:

Metadata

• Latest Version: 0.4.0
• Postgres Support: 17,16,15,14
• Need Load: Explicit Loading Required
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can be installed into other schemas
• Trusted: Trusted, Can be created by user with CREATE Privilege
• Schemas: N/A
• Requires: N/A

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: pg_parquet_$v
• RPM Ver : 0.4.0
• RPM Deps: N/A
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-pg-parquet
• DEB Ver : 0.4.0
• DEB Deps: N/A

Availability

Installation

Install pg_parquet via the pig CLI tool:

pig ext install pg_parquet

Install pg_parquet via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_parquet"]}' # -l <cls>

Install pg_parquet RPM from YUM repo directly:

dnf install pg_parquet_17;
dnf install pg_parquet_16;
dnf install pg_parquet_15;
dnf install pg_parquet_14;

Install pg_parquet DEB from APT repo directly:

apt install postgresql-17-pg-parquet;
apt install postgresql-16-pg-parquet;
apt install postgresql-15-pg-parquet;
apt install postgresql-14-pg-parquet;

Extension pg_parquet has to be loaded via shared_preload_libraries

shared_preload_libraries = 'pg_parquet'; # add to pg cluster config

Create pg_parquet extension on PostgreSQL cluster:

CREATE EXTENSION pg_parquet;