Life & fun · alternatives · 2026

24 alternatives to Pg_sorted_heap–Physically sorted PostgreSQL with builtin vector search

Sorted heap table AM for PostgreSQL with zone map scan pruning - skuznetsov/pg_sorted_heap

Pg_sorted_heap is a modified version of PostgreSQL that stores data in physically sorted order and includes built-in vector search capabilities. It is designed for developers and database administrators working with… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes.

1
Postgres as a VectorDB GUI▲162
Contribute to Z-Gort/Reservoirs-Lab development by creating an account on GitHub.
2024 · github.com · its alternatives →
2
Speeding up PostgreSQL through vectorized execution▲332
Vectorized executor to speed up PostgreSQL. Contribute to citusdata/postgres_vectorization_test development by creating an account on GitHub.
2014 · github.com · its alternatives →
3
PgDog – Scale Postgres without changing the app▲326
Hey HN! Lev and Justin here, authors of PgDog (https://pgdog.dev/), a connection pooler, load balancer and database sharder for PostgreSQL. If you build apps with a lot of traffic, you know the first thing to break is the database. We are solving this with a network proxy that works without requiring application code changes or database migrations. Our post from last year: https://news.ycombinator.com/item?id=44099187 The most important update: we are in production. Sharding is used a lot, with direct-to-shard queries (one shard per query) working pretty much…
Feb 2026 · github.com · its alternatives →
4
PgQueuer – Transform PostgreSQL into a Job Queue▲376
PgQueuer is a Python job queue that uses PostgreSQL for everything — queue storage, locking, notifications. No Redis, no RabbitMQ, no separate broker to operate. If your app already has Postgres, you already have the broker. After ~2 years and 26 minor releases, 1.0 ships today as the first stable release. Strict semver from here on. Thanks to everyone who contributed and left feedback!
2024 · github.com · its alternatives →
5
PgCat, Postgres pooler with sharding, load balancing and failover▲233
PostgreSQL pooler with sharding, load balancing and failover support. - postgresml/pgcat
2022 · github.com · its alternatives →
6
pg_flame – flamegraph visualizations of PostgreSQL query plans▲321
A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame
2019 · github.com · its alternatives →
7
Pg_replicate – Build Postgres replication applications in Rust▲216
A high-performance Postgres replication engine written in Rust. Embed it in your Rust application or run it as a standalone binary. - supabase/etl
2024 · github.com · its alternatives →
8
I open-sourced the in-memory PostgreSQL I built at work for E2E tests▲379
In-memory Postgres for unit/E2E tests. Contribute to hexclave/pgmock development by creating an account on GitHub.
2024 · github.com · its alternatives →
9
FastGraphRAG – Better RAG using good old PageRank▲457
Hey there HN! We’re Antonio, Luca, and Yuhang, and we’re excited to introduce Fast GraphRAG, an open-source RAG approach that leverages knowledge graphs and the 25 years old PageRank for better information retrieval and reasoning. Building a good RAG pipeline these days takes a lot of manual optimizations. Most engineers intuitively start from naive RAG: throw everything in a vector database and hope that semantic search is powerful enough. This can work for use cases where accuracy isn’t too important and hallucinations are tolerable, but it doesn’t work for more difficult queries that…
2024 · github.com · its alternatives →
10
OrioleDB Beta12 Features and Benchmarks▲55
Hey HN, I'm the creator of OrioleDB, an extension for PostgreSQL that serves as a drop-in replacement for the default Heap storage engine. It is designed to address scalability bottlenecks in PostgreSQL's buffer manager and reduce the WAL, enabling better utilization of modern multi-core CPUs and high‑performance storage systems. We are getting closer to GA. This release includes: - An index bridge to support all indexes that Heap supports - Support for rewinding recent changes in the database. - Tablespaces support - Fillfactor support - An orioledb_tree_stat() function for space…
2025 · orioledb.com · its alternatives →
11LA
Lantern – a PostgreSQL vector database for building AI applications▲196
We are excited to share Lantern! Lantern is a PostgreSQL vector database extension for building AI applications. Install and use our extension here: https://github.com/lanterndata/lantern We have the most complete feature set of all the PostgreSQL vector database extensions. Our database is built on top of usearch — a state of the art implementation of HNSW, the most scalable and performant algorithm for handling vector search. There’s three key metrics we track. CREATE INDEX time, SELECT throughput, and SELECT latency. We match or outperform pgvector and pg_embedding…
2023 · docs.lantern.dev · its alternatives →
12
Postgres extension for BM25 relevance-ranked full-text search▲203
Last summer we faced a conundrum at my company, Tiger Data, a Postgres cloud vendor whose main business is in timeseries data. We were trying to grow our business towards emerging AI-centric workloads and wanted to provide a state-of-the-art hybrid search stack in Postgres. We'd already built pgvectorscale in house with the goal of scaling semantic search beyond pgvector's main memory limitations. We just needed a scalable ranked keyword search solution too. The problem: core Postgres doesn't provide this; the leading Postgres BM25 extension, ParadeDB, is guarded behind AGPL; developing our…
Mar 2026 · github.com · its alternatives →
13
PgDog▲227
Scale PostgreSQL without changing your app
Jul 2026 · pgdog.dev · its alternatives →
14
Godb is a simple Go ORM for PostgreSQL, MySQL, SQLite and SQL Server▲205
A Go SQL query builder and struct mapper. Contribute to samonzeweb/godb development by creating an account on GitHub.
2016 · github.com · its alternatives →
15
Software Engineering Daily - Scaling PostgreSQL▲70
A look at modern database approaches and how Citus scales PG
2016 · softwareengineeringdaily.com · its alternatives →
16
Pgsemantic – Point at your Postgres DB, get vector search instantly▲18
Zero-config semantic search for any PostgreSQL database. pip install pgsemantic, three commands, done - varmabudharaju/pgsemantic
Mar 2026 · github.com · its alternatives →
17
Integer Map Data Structure▲91
This project presents a new data structure for storing ordered integer maps. The proposed data structure is a compressive, cache-friendly, radix tree that has performance comparable to an unordered map (`std::unordered_map`) and is an order of magnitude faster than an ordered map (`std::map`).
2024 · github.com · its alternatives →
18AU
A user interface for Postgres EXPLAIN that also gives tips▲50
pgMustard is a Postgres EXPLAIN visualisation tool that also gives performance advice, scored based on its potential to speed up your query.
2019 · pgmustard.com · its alternatives →
19
GraphQL for Postgres▲195
GraphQL for Postgres. Contribute to solidsnack/GraphpostgresQL development by creating an account on GitHub.
2015 · github.com · its alternatives →
20
BemiDB – Postgres read replica optimized for analytics▲209
Hi HN! We're Evgeny and Arjun, and we’re building a better way to do analytics with Postgres. We love Postgres for its simplicity, power, and rich ecosystem. But engineers have to still get bogged down with heavyweight and expensive OLAP systems when connecting an analytics data stack. Postgres is amazing at OLTP queries, but not for OLAP queries (large data scans and aggregations). Even in this case, we’ve still heard from countless scaling startups that they still try to use only a read replica to run analytics workloads since they don’t want to deal with the data engineering complexity of…
2024 · github.com · its alternatives →
21OA
OtterTune – Automated Database Tuning Service for RDS MySQL/Postgres▲164
Yo. OtterTune is a database optimization service. It uses machine learning to automatically tune your MySQL and Postgres configuration (i.e., RDS parameter groups) to improve performance and reduce costs. It does this by only looking at your database's runtime metrics (e.g., INNODB_METRICS, pg_stat_database, CloudWatch). We don't need to examine sensitive queries or user tables. We spun this project out of my research group at Carnegie Mellon University in 2020. This week we've announced that OtterTune is now available to the public. We are offering everyone a starter account to try it out…
2021 · its alternatives →
22
PostgreSQL performance and cost across 23 EC2 instance types▲97
Hey! I'm Andrei. I got frustrated by how people tend to build overcomplicated backend systems, being "motivated" by big tech case studies and popular books. So, I started exploring lean architecture, and building my digital garden of ideas, approaches and data that align with this direction. Here I want to present one of the tools – Sizing tool for PostgreSQL. I've benchmarked PostgreSQL on different EC2 instances and disks, with different initial data sets to see performance that these instances can give you. And I've built a tool to visualize this data, which I welcome you to explore. So,…
Jul 2026 · postgres.saneengineer.com · its alternatives →
23
PugSQL, a Python Port of HugSQL▲155
PugSQL is a Python library for interacting with your database the way the gods intended.
2019 · pugsql.org · its alternatives →
24
Open source, logical multi-master PostgreSQL replication▲151
Logical multi-master PostgreSQL replication. Contribute to pgEdge/spock development by creating an account on GitHub.
2025 · github.com · its alternatives →

Also compare

Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →