Stu Hood
banner
stuhood.sh
Stu Hood
@stuhood.sh
Working on transactional, Elastic-quality search for Postgres at https://www.paradedb.com/ - 日本語を勉強しています
Got it, thank you!
October 23, 2025 at 7:39 PM
Lovely. And then once found, it's reproducible? Does adding additional debug information break the repro?
October 23, 2025 at 7:26 PM
What flavor of stuff are you finding?
October 23, 2025 at 7:05 PM
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.
October 6, 2025 at 4:53 PM
Needs something like Community Notes to help deal with misinformation. www.lesswrong.com/posts/sx9wTy...
September 26, 2025 at 4:00 AM
But yea, lots of that scaling is premature, so! 😅
September 20, 2025 at 8:52 PM
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.
September 20, 2025 at 8:51 PM
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.
September 20, 2025 at 8:30 PM
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.
September 20, 2025 at 8:28 PM
It's also important to remember that your first pass of ranking is still very important: you can only re-rank whatever amount you over-query by in that first pass (maybe the top 10k), then re-rank them.
September 20, 2025 at 8:19 PM
This is true for some of the highest scale search systems, yes. But we've also seen it applied for the wrong reasons: for example, team boundaries where one team owns search infra and another that owns re-ranking and/or faceting.
September 20, 2025 at 8:17 PM
I'm fine with the popover, because it's very difficult to preserve formatting when translating: and if you can't preserve formatting, then doing it online seems less valuable.
August 27, 2025 at 8:28 PM
Until you compact an undo log or WAL by applying it to create a new snapshot! Not all use cases can afford to keep history forever.
August 27, 2025 at 8:08 PM
You can definitely do this with Vortex, although I'm not sure whether it does it by default for strings.
August 20, 2025 at 7:57 PM
Hooray! Thank you.
August 14, 2025 at 5:57 PM
In Python with mypy (which is only one of three+ type checkers), there is an option that you can toggle to allow calling untyped from typed.
August 6, 2025 at 2:22 PM
We're all in awe that we didn't know this existed. Thanks!
July 31, 2025 at 9:18 PM