BM25 is only as good as your tokens
Neon Lakebase Search is the search primitive of the Neon backend. One of the best things about it is that it ranks keyword results with BM25. That said, BM25 can only score the terms it's given.
Topic
PostgreSQL
PostgreSQL releases, ecosystem changes, operations, and performance.
pgx-bm25 1.0: BM25 ranked full-text search as a native PostgreSQL index
PostgreSQL News PGX Inc. has released version 1.0 of pgx-bm25, an extension that adds Okapi BM25 ranked full-text search to PostgreSQL as a native index access method. It supports PostgreSQL 17 and 18, and installs as bm25_native. CREATE EXTENSION bm25_native; CREATE INDEX docs_bm25 ON docs…
pg_plan_filter 1.0.0 released
PostgreSQL News pg_plan_filter version 1.0.0 has been released. This loadable module test sstatements against specific configured criteria before execution, raising an error if the criteria are violated. This allows administrators to prevent execution of certain queries on production databases.…
pg_vault_tde v1.7.2 : Critical crash fixes, new on-disk format, and stability improvements
PostgreSQL News Version 1.7.2 of pg_vault_tde is now available. This is a binary patch release where extension version stays at 1.7, but users can distinguish the build at runtime using pg_vault_tde_build_version(). This update focuses on critical stability, security, and correctness fixes: New…
pgvector 0.8.7 Released
PostgreSQL News pgvector 0.8.7 is now available. This release fixes a buffer overflow with IVFFlat index builds (CVE-2026-103484), which can lead to arbitrary code execution. Users are encouraged to upgrade when possible. More details: https://github.com/pgvector/pgvector/issues/1036 pgvector is…
pg_ivm 1.16 released
PostgreSQL News IVM Development Group is pleased to announce the release of pg_ivm 1.16. Changes since the v1.15 release include: What's Changed New features Add support for PostgreSQL 19 ( Devrim Gündüz ) Bug fixes Fix a segfault when an IMMV is maintained and dropped in the same transaction…
dbForge 2026.2 Adds a PostgreSQL Debugger, Visual Object Editors and Broader Context for dbForge AI Assistant
PostgreSQL News The release adds a PostgreSQL Debugger, visual editors for event triggers, functions and procedures, as well as file attachments and model choice in dbForge AI Assistant. Devart, a leading developer of database management software, has released dbForge 2026.2, the latest update…
Pgpool-II 4.7.3, 4.6.8, 4.5.13, 4.4.18 and 4.3.21 released.
PostgreSQL News What is Pgpool-II? Pgpool-II is a tool to add useful features to PostgreSQL, including: connection pooling load balancing automatic failover and more. Minor releases Pgpool Global Development Group is pleased to announce the availability of following versions of Pgpool-II: 4.7.3…
Dasha 1.8: index recommendations, I/O analysis, schema checks and log insights
PostgreSQL News Dasha is an open source performance dashboard for PostgreSQL fleets. It connects to your clusters with a read-only role, shows what the databases are doing right now, and explains what to do about it. Nothing is installed on the database hosts: no agent, and no extension beyond…
PL/Haskell v6.0 Released
PostgreSQL News We are pleased to announce the release of version 6.0 of the PL/Haskell extension. This extension allows users to write PostgreSQL functions in the Haskell functional programming language. Instructions can be found here. Version 6.0 adds the ability to work with range types.…
pgEdge Announces pgEdge Starfleet, a New Postgres Cloud Platform to Bridge the AI Prototype to Production Chasm
PostgreSQL News ALEXANDRIA, Va. — Sept. 28, 2026 — pgEdge, the leading open source Postgres company for agentic AI and enterprise applications, today announced pgEdge Starfleet, a new Postgres cloud database platform built to bridge the widening chasm between enterprise AI prototypes and actual…
Image: Neon Building a searchable photo library on the Neon backend with TanStack
Neon A photo library looks simple, but each photo carries files, metadata, vectors, and an owner. Atlas is a TanStack Start app that keeps all of it on the Neon backend, so one branch gives you a full preview of the app.
Image: Neon Neon gives you 100 projects for free, with 1 GB of Postgres storage each
Neon Database storage on the Neon Free plan is now 1 GB per project, up from 0.5 GB. You still get 100 projects, with existing projects getting the new limit automatically.
Image: Neon Generate embeddings with Neon AI Gateway
Neon Neon AI Gateway now serves embedding models on the same OpenAI-compatible endpoint and with the same credential you already use for chat. Generate vectors, store them in Lakebase Postgres, and query them with Lakebase Search, all inside one Neon branch.
Image: Neon pg_redact: Content-aware PII redaction with Jev, enforced in Postgres
Neon PII redaction in Postgres today works column by column. Its limitation is that it only works when each piece of personal data has its own column, which is rarely the case with free text.
Image: Neon Announcing @neon/effect
Neon @neon/effect brings the Neon SDK to Effect. Provision projects and branches, handle tagged errors and compose infrastructure workflows with retries, cancellation and timeouts.
Image: Neon How we systematically improved our reliability
Neon Earlier this year, we had two incidents in one week. After those incidents, we doubled down on reliability. This post summarizes the reliability work we've been rolling out since then to keep uptime high as our fleet, product, and customer base grow.
Image: Neon Lakebase Search: the retrieval primitive for agents on Neon
Neon Build the search engine, ingestion layer, and serving layer for agent retrieval with Lakebase Search, Functions, Object Storage, and AI Gateway.
Image: Neon Inside Skydive: building virtual coworkers, powered by Neon
Neon Skydive is a platform that lets teams build AI coworkers that do real work. When a Skydive agent needs a durable state, it deploys an isolated Neon backend mid-task, with no human in the path, and it takes it around a second.
Image: Neon Inside branch-based restores in Lakebase Postgres
Neon Restores are broken in managed OLTP, and they have been broken for a long time. They are slow, and they get slower with scale. The databases that need recovery most, the large production ones, are the ones left waiting the longest.
