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!
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.
Which post is this? Sorry, tricky thing to Google.
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...
Cartoon by Tommy Siegel
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-...
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.
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.
Passed the JLPT N5! 🎉
やった！
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.
Apache DataFusion meetup in San Francisco: luma.com/p7r6fp2z Thursday, February 19. We are looking for more speakers and attendees!
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...
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.
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
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
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
The Nakasendo Trail between Magome (馬籠宿) and Tsumago (妻籠宿) in the Kiso Valley, Nagano.
大仙公園（大阪）日本庭園の紅葉
仁徳天皇陵の側にある公園の中にある庭園
ライトアップの光に照らされた夜の紅葉が庭園の池に映り込んでいてとても綺麗でした
#青空写真部 #風景写真 #紅葉
Presenting the #rustlang quotes from the Mozilla QDB
brson.github.io/2025/11/21/r...
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?
Got it, thank you!
Lovely. And then once found, it's reproducible? Does adding additional debug information break the repro?
What flavor of stuff are you finding?
See you out there today! #NoKings
Almost like we founded the entire country on opposing this exact sentence.
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.
I will be watching this! I don't care!
Needs something like Community Notes to help deal with misinformation. www.lesswrong.com/posts/sx9wTy...
But yea, lots of that scaling is premature, so! 😅
