pg_sorted_heap
livePostgreSQL extension for sorted heap storage and vector search
Details
pg_sorted_heap is a PostgreSQL extension that adds a table access method for physically ordered data storage using primary keys and zone-map pruning. It also offers an HNSW index access method for built-in vector types and provides tools for GraphRAG queries directly within PostgreSQL.
Best fit users
- •PostgreSQL users
- •Data engineers
- •Database administrators
Why this one made the cut
This extension enhances PostgreSQL's capabilities for workloads requiring physical data locality, such as time-series data and event logs. It also enables efficient vector search and in-database GraphRAG queries without needing external services.
What makes it different
pg_sorted_heap integrates vector search and GraphRAG functionality directly within PostgreSQL, allowing these operations to stay within the database instead of requiring external systems.