Extensible Postgres: Blossom of Possibilities
Nurturing all, thriving in synergy, forging infinite possibilities!
Analytics: Big Data's New Challenger
T0 analytical performance, DuckDB Extension Battleground, HTAP's future
Parallelism, MPP, columnar compression, GPU acceleration, Parquet analysis
- pg_duckdb: Bringing extreme OLAP performance into PostgreSQL
- pg_mooncake: Columnar Table with top 10 ClickBench rankings
- pg_strom: GPU accelerating for PostgreSQL/PostGIS
- citus: Distributed HTAP/OLAP with columnar storage and acceleration
AI Ready: Baseline for RAG/Vector App
Vector database, one extension conquering the entire specialized niche
Complete in-db AI workflow: inference, training, storage, embedding, and RAG
- pgvector: Vector extension, IVFLAT & HNSW indexing, AVX512 acceleration
- pgml: Run CUDA with SQL in-database ML/Training/Embedding/Inference
- DiskANN,quantization,NN computation,text summarization,in-database RAG
Geospatial: De Facto GIS Standard
De facto standard for GIS, accelerating storage to computation, index & query
Route planning, sky indexing, IP geocoding, H3 indexing, GeoHash, point cloud
- PostGIS: Geographic/geometric/topological/raster extension
- pgrouting: GIS spatial path planning, and graph computation
- pointcloud: Storage and processing of LiDAR point cloud data
Time Series: Temporal Data Mastery
Enhanced time-series processing & analytics capabilities, for IoT, FinTech, APM,...
Simplify app dev with temporal tables, time travel, version control, cron tasks,...
- timescaledb:Process & Analysis Timeseries, continuous agg of streaming event
- temporal_tables, e-maj: time travel, table_version: version control table
- pg_cron / pg_task, pg_later, pg_background
Text Search: Built-in Search Engine
Built-in full-text search, with multi-language dict, word segmentation,...
FTS + SQL precise retrieval + vector fuzzy retrieval for hybrid search
- pg_search: Wrap tantivy into PG native storage, as an ES alternative
- pg_bestmatch and vchord_bm25: full-text search ranking with BM25
- Gronnga, zhparser,hunspell,pg_bigm/pg_trgm for full text search
Languages: Language of Your Choice
PostgreSQL is not just a database, but a full-featured data development platform
Support for 20+ stored procedure languages, putting even Oracle to shame
FDW Federation: Connecting Data Silos
Create data federations with FDW, becoming the data exchange hub
Uniformly access & ETL all heterogeneous data sources with SQL
Featured: Database as a Platform
Send/Receive HTTP requests, SMTP email, Compression, QR codes, Scan PDFs
Developing web app inside Postgres - Just use PostgreSQL for everything!
PIGSTY