TanStack DB with Sync provides an exciting new way to add end-to-end reactivity to your web applications, including optimistic UI updates. 🧵

6/ Parallel S3 uploads

Uploads no longer block layer writes. Upload throughput doubled, and ingest time in our benchmarks dropped.

5/ Smarter compaction

We now prioritize L0 compaction to avoid read amplification during ingestion. This dropped p99 read amplification by >50%.

4/ Scan prefetching

Instead of fetching one page at a time, Pageservers now prefetch up to 100. In our benchmarks, schema finalization dropped from 10h to 2.5h.

3/ Faster disk writes

Safekeepers now use sparse files and fewer flushes. WAL write throughput improved by 230%.

2/ WAL compression

WAL is now compressed with Zstd before it’s sent to Pageservers. This cut Safekeeper → Pageserver bandwidth by ~70%.

1/ Sharded ingest

We stopped broadcasting WAL to all shards and now route writes only where they’re needed. Less network traffic, lower CPU, and ~2× faster ingestion for large tenants.

pg_search is already available for all Neon databases in AWS regions using Postgres 17. If you’re in Azure or using other versions of Postgres, don’t worry, we’ll get to you shortly.

To install the extension, run:

We tested pg_search in Neon and full-text search queries were up to 1,000x faster than Postgres' native full-text search:

- COUNT(*) with search: 22,214ms → 770ms: 29x faster
- Top-N ranked search: 38,797ms → 81ms: 497x faster
- Filtered search: 31,890ms → 29ms: 1,100x faster

We're rolling out scheduled updates, and the ability for paid plans to specify an update window. These updates typically take only seconds to complete.

If you use the @1password.bsky.social extension, you can save your database credentials to your vault directly from the connection UI in Neon Console

[Now in Early Access] Monitor queries: You can view stats for active and past queries in the Console

Learn how to build AI Agents using serverless primitives.

@ahmadawais.com, CEO and founder of @langbase.com, will teach you at the Neon AI Agent Dev Tools Meetup in🗽 NYC on Feb 18.

RSVP on Luma: lu.ma/7wn1tmc0