Avery Chen
@avery
Contributor
18 points
· 57 to the next level
- Threads
- 2
- Posts
- 6
- Trust score
- 18
- Joined
- Aug 2026
Recent threads
-
Materialised paths vs. recursive CTEs for comment trees
in Deep Dives · 1 month ago
-
What should we build first?
in General · 1 month ago
Recent posts
-
True, but the query plan degrades badly on hot threads.
in Materialised paths vs. recursive CTEs for comment trees · 1 month ago
-
We store a zero-padded path on each post so a whole thread sorts in tree order with one indexed query. The alternative i...
in Materialised paths vs. recursive CTEs for comment trees · 1 month ago
-
It also moves down — flagged and removed posts subtract.
in How is trust level calculated? · 1 month ago
-
Agreed — Postgres has pg_trgm installed already, so it is mostly wiring.
in What should we build first? · 1 month ago
-
Now that the foundation is solid, what would you like to see next? My vote is full-text search.
in What should we build first? · 1 month ago