Advanced Analytics
These extensions let you run vector search, geospatial analysis, and machine learning inside the database, without exporting data to an external system.
pgvector
Exact and approximate nearest neighbor search, with L2 distance, inner product, and cosine distance.
Vectorized Queries
Process multiple data elements at once, using parallel computation and SIMD instructions on large datasets.
MADlib
Data-parallel mathematical, statistical, and machine learning algorithms that run in the database.
Directory Tables
Unified management of unstructured data on local or object storage.
RoaringBitmap
An efficient bitmap compression algorithm, suited to set operations over large collections.
Time-Series Data
Time-series tables that shard automatically by time, with continuous aggregates, columnar compression, and background jobs.