Extensible Postgres: Blossom of Possibilities
Nurturing all, thriving in synergy, forging infinite possibilities!
Analytics: Big Data's New Challenger
First-tier analytical performance, the main battleground in the DuckDB integration competition, a true hope for HTAP's future
Single-machine parallelism, distributed MPP, columnar compression, GPU acceleration, Parquet analysis - it has everything
- 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
Essential for LLM applications, vector database baseline, one vector extension conquering the entire specialized vector database field
Deep integration of databases and AI, complete in-database AI workflow: inference, training, storage, embedding generation, 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
The de facto standard for geographic information systems, accelerating all aspects from storage to computation, indexing to querying
Route planning, sky indexing, IP geocoding, H3 indexing, GeoHash, point cloud storage all readily available
- 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 data processing and analysis capabilities, providing tremendous support for IoT, FinTech, APM and other scenarios
Simplify application development with temporal tables, easily implement time travel, version control, scheduled tasks and more
- 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 capabilities that rival professional search engines, with multi-language dictionaries, Chinese word segmentation, ready out of the box
Full-text search, combined with SQL precise retrieval and vector fuzzy retrieval for hybrid search - the triathlon of search capabilities
- 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 over twenty stored procedure programming languages, putting even Oracle to shame
FDW Federation: Connecting Data Silos
Create data federations with FDW, becoming the central hub and exchange platform for all databases
Use SQL to uniformly access all heterogeneous data sources, perform cross-database ETL and cross-system integration
Featured: Database as a Platform
Send/receive HTTP requests, SMTP email, in-database compression, generate QR codes, retrieve PDF from web
Even develop web applications directly within the database - nothing PostgreSQL can't do, only what you haven't thought of
PIGSTY