Stu Hood

@stuhood.sh

Working on transactional, Elastic-quality search for Postgres at https://www.paradedb.com/ - 日本語を勉強しています

Last week on Pender Island, BC. Got out to explore sea life in the shallows on kayaks, but mostly unwound and ate/drank things!

A deck with Adirondack chairs overlooking a tree covered, ridge-wrapped ocean bay. The bay is full of widely spaced sailboats at anchor.

ParadeDB is hiring a platform/distributed systems engineer to come build ParadeDB Cloud with us. This is a high leverage role -- will get to make a lot of big technical decisions and report directly to me. North America only, strong preference for west coast. DMs open.

ParadeDB is working on vector search. Our implementation is designed to solve pgvector's limitations and integrate nicely with our existing full-text search features. We have room for one more engineer. If you've shipped production vector search before, I'd love to talk. DMs open.

Our next South Bay Systems meetup will be on March 31. We've got two awesome deep-dive talks from Sugu Sougoumarane (Consensus and Multigres) and @stuhood.sh (Full-Text Search and ParadeDB). Food and beverages will be provided, courtesy of our host, Snowflake. Register here: luma.com/2g3exvjw

South Bay Systems: Consensus & Full Text Search · Luma

Welcome to another edition of South Bay Systems! This time we bring you two wonderful talks: Sugu Sougoumarane will be speaking about deconstructing consensus…

luma.com

What's more shocking than ICE's plan to cram as many 8,500 humans into massive, soul-crushing warehouses? Seeing the actual DHS floor plan that echoes slavery ships and history's worst gulags with no rec space but a gun range for guards My new column on the camps www.inquirer.com/opinion/ice-...

The hidden ICE blueprint that should horrify every American | Will Bunch

An internal Department of Homeland Security document shows how ICE plans to cram thousands of detained human beings inside a Georgia warehouse.

inquirer.com

New (to me) coding agent use case: shrinking bug repros involving huge queries. Essentially: "this query reproduces a bug: please binary search to shrink it."

High-quality search is more than keyword matching. Personalization is what takes search from good to great. We're investing a lot in building the "unified retrieval stack" for Postgres this year. Expect lots of announcements. For now, here's how to build personalization today.

ParadeDB@paradedb.com · 7mo ago

Ankit (ex-Instacart) shows us how to build personalized search entirely inside PostgreSQL. A search for “king” could mean LOTR: Return of the King or The King’s Speech. To fix that: • Retrieve with BM25 • Rerank with embeddings + cosine similarity www.paradedb.com/blog/persona...

As part of our v0.20.0 release late last year we did a lot of work on increasing write throughput. Adding any index to a Postgres table trades off write speed for read speed, and BM25 indexes aren't any exception. So we set out to make things better .... www.paradedb.com/blog/increas...

How We Made Writes 10x Faster for Search

How ParadeDB achieved 10x improved write throughput through searchable buffers, background merging, and handling Postgres HOT chains.

paradedb.com

The #tokioconf speakers and talks just got posted: www.tokioconf.com Ticket sales are open! Since it is our first conference, it is hard to estimate how many people will come. We're starting conservative, only 200 tickets right now.

TokioConf 2026 | Be a Part of Tokio's Official Conference!

Join 300+ developers at the inaugural TokioConf 2026 to exchange ideas, learn from one another, and explore the future of async Rust. Hosted by the Tokio Project

tokioconf.com

I'm very excited about the work that we did on this: it allows for an extremely common full text search use case via a natural blend of fully compliant SQL syntax, with faceted aggregates that are familiar to full text search users. And it's fast! www.paradedb.com/blog/faceting

14x Faster Faceted Search in PostgreSQL with ParadeDB

Introducing faceted search in ParadeDB - bringing the power of search engine faceting to PostgreSQL with single-query aggregations.

paradedb.com

Faceting looks simple, it's just counts next to search results right? But making it fast and ergonomic is harder than it seems. We just shipped native faceting in ParadeDB: it runs inside Postgres, in a index single pass, and is 14× faster over large result sets👇 www.paradedb.com/blog/faceting

14x Faster Faceted Search in PostgreSQL with ParadeDB

Introducing faceted search in ParadeDB - bringing the power of search engine faceting to PostgreSQL with single-query aggregations.

paradedb.com

We've shown you parts of our V2 SQL API over the last month, but here's a full post looking at everything you can do with it. Check out the side by side of the CREATE TABLE for old and new APIs, it's so much better ❤️. www.paradedb.com/blog/v2api

Deep Dive into ParadeDB's v2 API: The Future of SQL Search

Explore ParadeDB's v2 API that eliminates schema duplication, simplifies tokenization, and provides transparent search operators for intuitive SQL-based full-text search.

paradedb.com