Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Index table - turn off Reverse Index #141

Open
syatihoko opened this issue Apr 12, 2024 · 1 comment
Open

Index table - turn off Reverse Index #141

syatihoko opened this issue Apr 12, 2024 · 1 comment

Comments

@syatihoko
Copy link

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 )

@msaf1980
Copy link
Collaborator

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).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants