carbon-clickhouse icon indicating copy to clipboard operation
carbon-clickhouse copied to clipboard

Index table - turn off Reverse Index

Open syatihoko opened this issue 10 months ago • 1 comments

Is it possible to disable the formation of a reverse index? Now, when because of it due to the growth of the table, queries are use a lot of memory. Moreover, in the old Tree schema, where I do not use a reverse index, there is no such problem.

Comparing Type Index vs Tree, For Tree enough 10Gb for Index need 50Gb (Error: Storage read limit for memory )

syatihoko avatar Apr 12 '24 12:04 syatihoko

Not at this time. Disabling reverse index is performance problem for some queries, for example

a.*.b.c.d or {a,ab}.*.b.c.d

On large system it's wery heavy. queries are use a lot of memory - what queries ? For some queries graphite-clickhouse can be tuned for use direct/reverse index. If you past query examples, auto detect can be improved also (may be need a open issue in graphite-clickhouse).

msaf1980 avatar Apr 26 '24 04:04 msaf1980