Postgres

Table Partitioning

• Table Partitioning Docs

Data Types

JSONB

PGConf NYC 2021 - Understanding of Jsonb Performance by Oleg Bartunov

pg_jsonschema: JSON Schema support for Postgres

Foreign Data Wrappers

Parquet

• Parquet S3
• Parquet and Postgres in the Data Lake

Export

Postgres to Parquet

• connector-x

Using BigQuery on GCP

Extensions

https://github.com/tcdi/pgx

https://supabase.com/blog/choosing-a-postgres-primary-key