How to organize a rapidly growing hierarchical table?

Question

Yii

Good afternoon,
Please tell me - how would you organize the structure of a table with hierarchical comments? In fact, the table does not store comments, but in my opinion this is the most successful example.
I'm considering several options. Nested Set (loss when writing and updating - overwriting extreme keys) and
adjacency-list (recursion when building descendants-ancestors) A rather robust data growth rate is implied.
I also considered Nested Set using several trees in one table. But I don't know how it will affect performance.
Are there similar solutions for Yii2 (behaviors). Does n't mean NestedSetBehaviorin its purest form, and the behavior is based on the correct decision of the structure and storage about my question.

Answer 1

Postgres ltree
Search by speed like Nested Set, modification is faster.

Answer 2

demiurg.livejournal.com/53125.html