Do We Still Have to Denormalize? Have Your Schema and Search It Too
Comments on “Do We Still Have to Denormalize? Have Your Schema and Search It Too”
3 judges. Scored by all three judges. Only the day’s top stories get the claim check. How far stories are checked
ParadeDB's Stu Hood describes making multi-table search joins fast in Postgres without denormalizing data into an external engine. On the StackOverflow benchmark, a three-table top-K search that took about two minutes in vanilla Postgres runs in roughly 100 ms, using a new Rank Join operator and a DataFusion-based columnar executor.
Why it ranked
No. 109 of 137 with a score of 0.57. The panel rated it highest on technical depth (0.92) and new information (0.89), lowest on audience breadth (0.52). Placed No. 109, No. 107 by score alone: the seventh Data story of the day (−0.080). The placement terms move stories; they are not part of the score.
- AI judgeJudge 2claude-haiku-5-5
- Technical database engineering writeup on search joins in Postgres with benchmarks and mechanisms; vendor-promotional tone and self-reported benchmarks limit substantiation and breadth of audience.
- AI judgeJudge 3gpt-5.6-luna
- A technically detailed engineering write-up presents a new search-join executor, algorithms, implementation mechanics, and reproducible benchmarks. It is highly relevant to database and search builders, though vendor framing and single-dataset comparisons moderately limit generality.
Each judge wrote its line after answering the rubric, with the site and the author still hidden. Every answer behind this is in the table under Score.
Score
0.57total under rubric v2.3
- Significance0.56
- Reader interest0.72
- Audience breadth0.52
- Practical relevance0.71
- Substantiated0.83
- Technical depth0.92
- New information0.89
- Counts against: Promotional0.34
- Counts against: Overclaim0.35
Each judge’s answer per question (0–1), their mean and spread, and what the question adds to the score (weight × mean).
| Question | Judge 1 | Judge 2 | Judge 3 | Mean | Spread | Weight | Contribution (weight times mean) |
|---|---|---|---|---|---|---|---|
| SignificanceHow much does this change what people in tech know or can do? | 0.69 | 0.35 | 0.63 | 0.56 | 0.34 | +0.24 | +0.133 |
| Reader interestWould a well-informed senior engineer or tech founder want to read this today, and likely pass it on? | 0.75 | 0.60 | 0.82 | 0.72 | 0.22 | +0.26 | +0.188 |
| Audience breadthHow many people who build technology does it concern? | 0.61 | 0.40 | 0.55 | 0.52 | 0.21 | +0.13 | +0.068 |
| Practical relevanceHow useful is it to someone who builds software or tech products? | 0.80 | 0.60 | 0.72 | 0.71 | 0.20 | +0.22 | +0.156 |
| SubstantiatedHow well is it backed? Consider whether it is the primary source, and whether its main claims come with data, code, a demo, a reproducible method or citations. | 0.94 | 0.70 | 0.86 | 0.83 | 0.24 | +0.05 | +0.042 |
| Technical depthHow technically substantive is it? | 0.98 | 0.85 | 0.93 | 0.92 | 0.13 | +0.05 | +0.046 |
| New informationDoes it contain information absent from the stories covered in the last 7 days (list provided)? | 0.89 | 0.80 | 0.97 | 0.89 | 0.17 | +0.05 | +0.044 |
| PromotionalIs it mainly marketing with little substance (a press release, ad or sponsored post with no real information)? A launch post that carries real news is not promotional. | 0.13 | 0.50 | 0.38 | 0.34 | 0.37 | −0.19 | −0.064 |
| OverclaimDo the headline or conclusions claim more than the body supports? | 0.37 | 0.50 | 0.18 | 0.35 | 0.32 | −0.11 | −0.038 |
| Sum of contributions | +0.574 | ||||||
| Claim-check penalty | 0.000 | ||||||
| Total, as published | 0.574 | ||||||
Spread is the highest minus the lowest judge answer. marks a spread above 0.40: the judges disagree, and the story is marked contested.
The badge for this ranking, for the author's page or anyone's: one line of HTML, and it links back here.
<a href="https://rubric.hrih.si/editions/2026-11-04/109/"><img src="https://rubric.hrih.si/badge/2026-11-04/109.svg" alt="Ranked #109 on Rubric, 4 Nov 2026" width="245" height="28"></a>Also covered by
No other coverage was clustered with this story.
Elsewhere
Elsewhere: HN 6 pts, not on front page
Recorded for context only, checked 4 Nov 2026, 05:47 UTC. It played no part in the ranking.