Hi @Karan Kumar, this PR tells about creating index on

druid_tasks

table, I’m thinking to create on

druid_segments

table. The concern I’m having is, with the index I’m proposing, will it make write operation very costly cause with every segment metadata write, index need to be updated. Will this hamper ingestion performance?

Daily segments files created number is increasing gradually as we are seeing organic growth

But we are also focusing on our compaction tunings as well

Hi @Karan Kumar, got anything on this?