Sign in

Stu Hood

@stuhood.sh
502 followers 304 following 77 posts

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

PostsRepliesMedia
Reposted by Stu Hood
ParadeDB @paradedb.com · 01/10/2026
Two weeks ago, @planetscale.com launched TIN. They benchmarked it against us, and it was very fast. So we spent those two weeks making ParadeDB faster without their tradeoffs. Today, we are faster than TIN. www.paradedb.com/blog/opening...
paradedb.com
PlanetScale Released Text Search and We Have a Lot to Say (Part I)
Two BM25 optimizations and benchmark configuration changes inspired by PlanetScale's TIN benchmarks make ParadeDB's text search faster without changing its document identifiers.
2166
Reposted by Stu Hood
WIRED @wired.com · 15/09/2026
Following mass layoffs in 2022 and 2023, many tech workers turned against their employers. When liberal politicians also rallied against Silicon Valley, their backers turned to Donald Trump. www.wired.com/story/agains...
wired.com
Why the Postpandemic Tech Bust Sent Billionaires to Trump
Following mass layoffs in 2022 and 2023, many tech workers turned against their employers. When liberal politicians also rallied against Silicon Valley, their backers turned to Donald Trump.
67328
Reposted by Stu Hood
Andrew Lamb @andrewlamb1111.bsky.social · 02/09/2026
What is a canonical JoinGraph API (aka the programming interface for join order enumeration in query optimizers)? I know what it looks like in my past experience but is there something more standard? @danielheres.bsky.social and I are researching this for DataFusion: github.com/apache/dataf...
github.com
feat: cost-based join order enumeration by Dandandan · Pull Request #24456 · apache/datafusion
Which issue does this PR close? Related to apache/datafusion#3929 Rationale for this change Depends on: Derive total_byte_size for join statistics #24536 feat: derive a distinct count from prima...
0121
Stu Hood @stuhood.sh · 24/07/2026
Whereabouts are you?
100
Reposted by Stu Hood
ParadeDB @paradedb.com · 23/07/2026
You have a product, and it needs search. You have agents, and they need retrieval. We're building ParadeDB Cloud for you, so you can focus on shipping: one Postgres for your data, full-text search, vector retrieval, and aggregations. Waitlist open now: paradedb.com/cloud/
paradedb.com
ParadeDB Cloud — Join the waitlist
One Postgres for your application data, full-text search, vector retrieval, and aggregations. Join the waitlist for early access.
031
Stu Hood @stuhood.sh · 17/07/2026
This talk discusses the techniques that ParadeDB uses to achieve its speedups, and why they are difficult to achieve with discreet Postgres indexes. Thanks for hosting, @pgconf.dev!
000
Reposted by Stu Hood
David_j_roth @davidjroth.bsky.social · 16/06/2026
The war on metaphor is over and we lost. defector.com/promises-mad...
defector.com
Promises Made, Promises Kept: The Lincoln Memorial Reflecting Pool Absolutely Looks Like Shit Now | Defector
If everyone in the United States wasn’t living downstream from its consequences, it would be a pretty good tragic flaw that Donald Trump wants more than anything to be seen as a brilliant man who has ...
1614637837
Stu Hood @stuhood.sh · 01/06/2026
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.
000
Reposted by Stu Hood
Philippe Noël @philippemnoel.bsky.social · 19/05/2026
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.
051
Stu Hood @stuhood.sh · 18/05/2026
Ebbett's Pass (CA-4) is wonderful too!
040
Reposted by Stu Hood
Philippe Noël @philippemnoel.bsky.social · 08/05/2026
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.
081
Stu Hood @stuhood.sh · 05/05/2026
Great talk! Did anyone there suggest `block_in_place`? I still suspect that it would reduce context switching compared to having separate CPU and IO pools. github.com/apache/dataf...
github.com
Move CPU Bound Tasks off Tokio Threadpool · Issue #13692 · apache/datafusion
Is your feature request related to a problem or challenge? DataFusion currently performs CPU-bound work on the tokio runtime and this can lead to issues where IO tasks are starved and unable to ade...
210
Reposted by Stu Hood
ParadeDB @paradedb.com · 06/04/2026
Full-text search was solved in 2016, Lucene had owned the space for a decade. Rewriting it in Rust, as a side project, on a plane sounds like a terrible idea. Enter Paul Masurel and Tantivy ... www.paradedb.com/blog/tantivy...
paradedb.com
A Conversation with Paul Masurel, Creator of Tantivy
We sat down with Paul Masurel (creator of Tantivy and co-founder of Quickwit) to talk about building a search engine in Rust, following the competitive happy-path with Lucene, open-source maintenance,...
042
Reposted by Stu Hood
South Bay Systems @southbaysystems.xyz · 04/04/2026
The recording from the last talk is up! youtu.be/TeFsBVIYBis
youtu.be
Generalized Consensus & ​Native Top-K Joins in ParadeDB
YouTube video by South Bay Systems
012
Stu Hood @stuhood.sh · 03/04/2026
We really need it here.
010
Reposted by Stu Hood
Qian Li @qianli.dev · 17/03/2026
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
luma.com
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…
066
Stu Hood @stuhood.sh · 10/03/2026
This would be such a glow up for 4th and King in SF. And the proximity to Mission Rock would compound that.
010
Stu Hood @stuhood.sh · 05/03/2026
I'll be speaking at PGConf.dev about how @paradedb.bsky.social uses Postgres's IAM and Custom Scan APIs to accelerate Top-K over JOINs: 2026.pgconf.dev/session/682 See you there!
2026.pgconf.dev
PGConf.devLinkedInMastodonGithub
040
Stu Hood @stuhood.sh · 04/03/2026
Thank you! When I was trying to think of which "Why" might have inspired a bunch of debate about AI, my mind went to "Why the Lucky Stiff" first for some reason. Hope he's happy wherever he is.
120
Stu Hood @stuhood.sh · 04/03/2026
Which post is this? Sorry, tricky thing to Google.
100
Reposted by Stu Hood
ParadeDB @paradedb.com · 03/03/2026
Top K is a deceptively hard problem in Postgres. "Give me the 10 best rows" works until you add filters and text search, then GIN can't sort and B-trees can't search. BM25 indexes handle equality, sort, and range in one data structure. Here's why that matters: www.paradedb.com/blog/optimiz...
paradedb.com
How We Optimized Top K in Postgres
How ParadeDB uses principles from search engines to optimize Postgres' Top K performance.
031
Reposted by Stu Hood
Robert Reich @rbreich.bsky.social · 03/03/2026
Cartoon by Tommy Siegel
8566651686
Reposted by Stu Hood
Will Bunch @willbunch.bsky.social · 22/02/2026
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-...
inquirer.com
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.
33680994395
Stu Hood @stuhood.sh · 17/02/2026
Meanwhile, they are a really unfortunate part of the streaming broadcast. All of the mics that they have to pick up the noises of the sport (skis on snow, etc) pick up mostly drone noise instead.
010
Stu Hood @stuhood.sh · 11/02/2026
I feel like the "persistent context" that entire.io/blog/hello-e... is built around could instead be... Code comments? Docs? TODO lists? I don't see the upside in hiding the context from users in a binary format, but it has definite downsides.
entire.io
Hello Entire World · Entire Blog
Announcing Entire with $60 million seed round and shipping our first product, called Checkpoints.
020
Stu Hood @stuhood.sh · 30/01/2026
Passed the JLPT N5! 🎉 やった!
161
Stu Hood @stuhood.sh · 22/01/2026
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."
083
Reposted by Stu Hood
Philippe Noël @philippemnoel.bsky.social · 22/01/2026
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.
021
Reposted by Stu Hood
Andrew Lamb @andrewlamb1111.bsky.social · 17/01/2026
Apache DataFusion meetup in San Francisco: luma.com/p7r6fp2z Thursday, February 19. We are looking for more speakers and attendees!
luma.com
San Francisco Apache DataFusion Meetup · Luma
Join us for an evening of talks and community discussion about Apache DataFusion and its growing role in modern data infrastructure. This year’s meetup will…
081
Reposted by Stu Hood
ParadeDB @paradedb.com · 14/01/2026
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...
paradedb.com
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.
041
Reposted by Stu Hood
Carl Lerche @carllerche.com · 08/01/2026
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.com
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
2114
Stu Hood @stuhood.sh · 10/12/2025
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
paradedb.com
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.
020
Reposted by Stu Hood
ParadeDB @paradedb.com · 10/12/2025
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
paradedb.com
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.
051
Reposted by Stu Hood
ParadeDB @paradedb.com · 04/12/2025
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
paradedb.com
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.
071
Stu Hood @stuhood.sh · 25/11/2025
The Nakasendo Trail between Magome (馬籠宿) and Tsumago (妻籠宿) in the Kiso Valley, Nagano.
030
Reposted by Stu Hood
spring rain @springrain303.bsky.social · 24/11/2025
大仙公園(大阪)日本庭園の紅葉 仁徳天皇陵の側にある公園の中にある庭園 ライトアップの光に照らされた夜の紅葉が庭園の池に映り込んでいてとても綺麗でした #青空写真部 #風景写真 #紅葉
0622
Reposted by Stu Hood
Steve Klabnik @steveklabnik.com · 21/11/2025
Presenting the #rustlang quotes from the Mozilla QDB brson.github.io/2025/11/21/r...
brson.github.io
Presenting the Rust quotes from the Mozilla QDB
2396
Stu Hood @stuhood.sh · 22/11/2025
What would that look like when you use a variable twice in a closure? Two `move` calls, or an error suggesting that it can only be moved once?
000
Stu Hood @stuhood.sh · 23/10/2025
Got it, thank you!
000
Stu Hood @stuhood.sh · 23/10/2025
Lovely. And then once found, it's reproducible? Does adding additional debug information break the repro?
100
Stu Hood @stuhood.sh · 23/10/2025
What flavor of stuff are you finding?
100
Stu Hood @stuhood.sh · 18/10/2025
See you out there today! #NoKings
040
Reposted by Stu Hood
Ben Collins @bencollins.bsky.social · 15/10/2025
Almost like we founded the entire country on opposing this exact sentence.
178108912606
Stu Hood @stuhood.sh · 06/10/2025
I think that they've done such a good job with the software that I don't miss Android Auto (supporting CarPlay alone gets you 58% of the US market and leaves out 41%). As long as they continue investing to stay ahead, it's the right decision, imo.
000
Stu Hood @stuhood.sh · 03/10/2025
I will be watching this! I don't care!
020
Stu Hood @stuhood.sh · 26/09/2025
Needs something like Community Notes to help deal with misinformation. www.lesswrong.com/posts/sx9wTy...
010
Stu Hood @stuhood.sh · 20/09/2025
But yea, lots of that scaling is premature, so! 😅
120
Stu Hood @stuhood.sh · 20/09/2025
If the data that is going into the calculation is within the same Postgres instance, then transactional boundaries are preserved... if it's not, and you're making network calls, then totally. At scale (either for team boundaries or performance) personalization data is likely to be living elsewhere.
200
Stu Hood @stuhood.sh · 20/09/2025
I like these buckets, but one exception here is when ordering by recency: immediately after creating something, regardless of result size, you expect to be able to find it in time order.
010
Stu Hood @stuhood.sh · 20/09/2025
We don't yet, but I suspect that we'll support re-ranking directly in ParadeDB. Elastic has a simple DSL for some re-ranking use cases: for us, the natural fit would be arbitrary (PL)SQL. Rust extensions are also easier than ever to build: defining a fast(er) UDF to compute a score would work too.
110