Discussion on Reevaluating Inverted Index for Logs Table
TLDR Varaprasad expressed concerns about existing search time in logs table. Srikanth suggested to reevaluate the use of inverted index and asked Varaprasad to create an issue for this.
Srikanth
Fri, 27 Oct 2023 12:04:11 UTCThe last time we tested the inverted index, it didn't bring any significant change, but it has been quite some time since then, and I think we should reevaluate this.
Srikanth
Fri, 27 Oct 2023 12:04:24 UTCCan you create issue here
SigNoz Community
Indexed 1061 threads
Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI
View in App
Varaprasad
Mon, 23 Oct 2023 19:18:20 UTCHI.. is there any future roadmap to have inverted index for logs table , seems existing tokenby_v1 is taking time to search for a string in body column. *Elapsed: 176.632 sec, read 1.67 billion rows, 3.87 TB* (INDEX body_idx body TYPE tokenbf_v1(10240, 3, 0) GRANULARITY 4)