kfaraz commented on issue #18331:
URL: https://github.com/apache/druid/issues/18331#issuecomment-3153678229
> We have attempted the following tuning options with no meaningful
improvement:
> Disabling Smart Segment Loading.
> Tested maxSegmentsToMove with various values between 100 and 1000.
> Testing useRoundRobinSegmentAssignment with both enabled and disabled
states.
@aiden-sun , changing these configs would not help. I would advise keeping
these configs on their default values.
Could you share the total number of segments that you have for each segment
granularity?
<details>
<summary>This query might help</summary>
```sql
SELECT "datasource",
CASE
WHEN "start" = '-146136543-09-08T08:23:32.096Z' AND "end" =
'146140482-04-24T15:36:27.903Z' THEN 'All'
WHEN "start" LIKE '%-01-01T00:00:00.000Z' AND "end" LIKE
'%-01-01T00:00:00.000Z' THEN 'Year'
WHEN "start" LIKE '%-01T00:00:00.000Z' AND "end" LIKE
'%-01T00:00:00.000Z' THEN 'Month'
WHEN "start" LIKE '%T00:00:00.000Z' AND "end" LIKE '%T00:00:00.000Z'
THEN 'Day'
WHEN "start" LIKE '%:00:00.000Z' AND "end" LIKE '%:00:00.000Z' THEN
'Hour'
WHEN "start" LIKE '%:00.000Z' AND "end" LIKE '%:00.000Z' THEN 'Minute'
ELSE 'Sub minute'
END AS "time_span",
COUNT(*)
FROM sys.segments
GROUP BY 1, 2
ORDER BY 1, 2
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
