did you use materialized paths for comment relationships? it's super efficient.
No, I didn't even know about ltree until just now. I used the adjacency list strategy with a recursive CTE.
- Upvoted for telling me about ltree
- Downvoted for lack of trolling me