Top all-time · #7002
erthalion.info
Personal blog · erthalion.infodataprogrammingsystems
erthalion.info is a personal blog at erthalion.info about data, programming and systems. Since 2014, 11 different Hacker News readers have linked it 20 times, most often “Evolution of tree data structures for indexing: more than it sounds”. It is still writing: the last post was on 2026-03-11, and you can follow it by feed.
Too few sampled comments (1) to say how often HN recommends it.?
Why HN links it
One commenter cites this post as the explanation of the PostgreSQL 14 JSONB subscripting syntax, which allows updating deep JSON values with a simple UPDATE statement.
Summarised by Claude from a sample of 1 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Most-linked posts?
- Evolution of tree data structures for indexing: more than it sounds3 people · 3 mentions · first linked 2020-11-28
- Running fast and slow: experiments with BPF programs performance (2022)2 people · 2 mentions · first linked 2022-12-30
- How many engineers does it take to make subscripting work?2 people · 2 mentions · first linked 2021-05-01
- Jsonb: Few more stories about the performance (2017)2 people · 2 mentions · first linked 2020-08-12
What Hacker News says?
Another exciting feature in PG14 is the new JSONB syntax[0], which makes it easy to update deep JSON values - UPDATE table SET some_jsonb_column['person']['bio']['age'] = '99'; [0] https://erthalion.info/2021/03/03/subscripting/
Comment linking /2021/03/03/subscripting/
on “An early look at Postgres 14: Performance and monitoring Improvements”Submitted PostgreSQL at low level: stay curious as a story · 255 points
HN discussionSubmitted Jsonb: Stories about performance as a story · 132 points
HN discussionSubmitted How many engineers does it take to make subscripting work? as a story · 122 points
HN discussionSubmitted Evolution of tree data structures for indexing as a story · 101 points
HN discussionSubmitted Demand the impossible: Rigorous database benchmarking as a story · 58 points
HN discussionSubmitted Evolution of tree data structures for indexing: more than it sounds as a story · 7 points
HN discussionSubmitted What's new in Linux kernel for PostgreSQL as a story · 5 points
HN discussionSubmitted Evolution of tree data structures for indexing: more than it sounds as a story · 4 points
HN discussionSubmitted Evolution of tree data structures for indexing (2020) as a story · 3 points
HN discussionSubmitted Evolution of tree data structures for indexing: more exciting than it sounds as a story · 3 points
HN discussionSubmitted Running fast and slow: experiments with BPF programs performance (2022) as a story · 2 points
HN discussionSubmitted Jsonb: Few more stories about the performance (2017) as a story · 2 points
HN discussionSubmitted Query Optimizer and Chess? as a story · 2 points
HN discussionSubmitted Milliseconds, Terabytes, Microjoules: energy aware performance for modern times as a story · 1 points
HN discussionSubmitted Running fast and slow: experiments with BPF programs performance as a story · 1 points
HN discussionSubmitted Benchmarking PostgreSQL's JSON Field as a story · 1 points
HN discussionSubmitted How to convert your data to jsonb? as a story · 1 points
HN discussionSubmitted Custom Paginator – what do you think? as a story · 1 points
HN discussionSubmitted Notes about the development of a xmpp client as a story · 1 points
HN discussion
