carbon-clickhouse
carbon-clickhouse copied to clipboard
Index table - turn off Reverse Index
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 )
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).