nowfound

Life & fun · March 6, 2026

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–Physically sorted PostgreSQL with builtin vector search launched on March 6, 2026 with 10 votes, #1,177 of 23,380 launches that month and more than 90% of that year's launches.

Visit github.com ↗Alternativestop 5% of March 2026

In plain words

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 PostgreSQL who need efficient vector similarity searches without external extensions. The physically sorted heap approach aims to improve performance for range queries and vector operations compared to standard PostgreSQL installations.

written from the facts on this page · September 2026

Does a similar job

all alternatives →
  • Postgres as a VectorDB GUI2024 · github.com · ▲162

    Contribute to Z-Gort/Reservoirs-Lab development by creating an account on GitHub.

  • Speeding up PostgreSQL through vectorized execution2014 · github.com · ▲332

    Vectorized executor to speed up PostgreSQL. Contribute to citusdata/postgres_vectorization_test development by creating an account on GitHub.

  • PgDog – Scale Postgres without changing the appFeb 2026 · github.com · ▲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…

  • PgQueuer – Transform PostgreSQL into a Job Queue2024 · github.com · ▲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!

  • PgCat, Postgres pooler with sharding, load balancing and failover2022 · github.com · ▲233

    PostgreSQL pooler with sharding, load balancing and failover support. - postgresml/pgcat

  • pg_flame – flamegraph visualizations of PostgreSQL query plans2019 · github.com · ▲321

    A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame

More life & fun this month

the category →

Source: Show HN post ↗

Launched alongside, March 2026

the whole month →
  • AI-native CRM that builds itself and does work for you

    AI · Mar 2026 · lightfield.app

  • Tobira.ai▲728

    A network where AI agents find deals for their humans

    AI · Mar 2026 · tobira.ai

  • Switch from ChatGPT to Claude with import memory feature

    AI · Mar 2026 · claude.com

  • Littlebird remembers everything across your meetings, messages, docs, and apps, then takes action so you can recall any detail and never lose context.

    AI · Mar 2026 · littlebird.ai

  • Your AI Coworker that proactively executes tasks

    AI · Mar 2026 · viktor.com

  • Jupid▲659

    File your taxes with Claude Code

    Commerce · Mar 2026 · jupid.com