Neon

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

TanStack DB adds optimistic updates on top, making your UIs feel snappy, not just for GET requests, but also when mutating data from the UI.

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

Whenever an agent, background task, or webhook function mutates the database, the changes instantly propagate to all connected client devices, and the associated UIs update in real time.

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

It's magical when you update a row in your db and connected UIs instantly update. Real-time UI isn’t a new concept, but sync engines like ElectricSQL turn Postgres into the source of truth for the sync, simplifying the mental model needed to build reactive updates - just write to the database!

In the last few months, we've been working on making Neon storage faster. Here are 7 improvements we shipped to boost performance under the hood 🧵

7/ Better sharding policy We now shard earlier and more gradually: 4 shards at 16 GB, 16 at 2 TB. This improved ingest performance by 17.5% for mid-size tenants. More info on sharding: neon.com/blog/how-we-...

In the last few months, we've been working on making Neon storage faster. Here are 7 improvements we shipped to boost performance under the hood 🧵

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

In the last few months, we've been working on making Neon storage faster. Here are 7 improvements we shipped to boost performance under the hood 🧵

3/ Faster disk writes Safekeepers now use sparse files and fewer flushes. WAL write throughput improved by 230%.

In the last few months, we've been working on making Neon storage faster. Here are 7 improvements we shipped to boost performance under the hood 🧵

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.

We’ve partnered with @paradedb.bsky.social to bring pg_search to all Neon databases. 💥 This extension delivers Elasticsearch-grade full text search without leaving Postgres. Benchmark results here 👇, summary in 🧵 neon.tech/blog/pgsearc...

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’ve partnered with @paradedb.bsky.social to bring pg_search to all Neon databases. 💥 This extension delivers Elasticsearch-grade full text search without leaving Postgres. Benchmark results here 👇, summary in 🧵 neon.tech/blog/pgsearc...

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’ve partnered with @paradedb.bsky.social to bring pg_search to all Neon databases. 💥 This extension delivers Elasticsearch-grade full text search without leaving Postgres. Benchmark results here 👇, summary in 🧵 neon.tech/blog/pgsearc...

Postgres has full-text search, but it has some limitations: - GIN indexes aren’t optimized for ranking - ts_rank doesn’t match modern relevance algorithms like BM25 - No fuzzy search or typo tolerance - Slow faceted aggregations

This week we shipped changes to help you: - 📊Monitor queries - 🔒Save db creds to 1Password - 🗓️Specify a schedule for Postgres updates Read on for details:

Scheduled Updates - We automatically upgrade sleeping computes with new Postgres minor versions, security patches, etc but what if your DB never scales to zero?

This week we shipped changes to help you: - 📊Monitor queries - 🔒Save db creds to 1Password - 🗓️Specify a schedule for Postgres updates Read on for details:

Scheduled Updates - We automatically upgrade sleeping computes with new Postgres minor versions, security patches, etc but what if your DB never scales to zero?

This week we shipped changes to help you: - 📊Monitor queries - 🔒Save db creds to 1Password - 🗓️Specify a schedule for Postgres updates Read on for details:

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