> For better query performance, you will want t...
# general
y
For better query performance, you will want to ensure a good (
free system memory
/ total size of all
druid.segmentCache.locations
) ratio so that a greater proportion of segments can be kept in memory.
Hi, any suggestion for ratio to start with? which metrics should I look for? in order to tune? Segment Query time? Thank you.
a
1 to 15, ensure you are using SSD or NVMe
✅ 1
metrics to look for is
query/segment/time
query/time
a
Hi Arun, Is the ratio 1 GB of free memory -> 15 GB of segment cache data? Can we use the cache size from the web console as reference? Regards, AR.