[ https://issues.apache.org/jira/browse/PHOENIX-6436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lars Hofhansl updated PHOENIX-6436: ----------------------------------- Fix Version/s: 5.1.2 5.2.0 4.16.1 > OrderedResultIterator overestimates memory requirements. > -------------------------------------------------------- > > Key: PHOENIX-6436 > URL: https://issues.apache.org/jira/browse/PHOENIX-6436 > Project: Phoenix > Issue Type: Wish > Reporter: Lars Hofhansl > Assignee: Lars Hofhansl > Priority: Major > Fix For: 4.16.1, 5.2.0, 5.1.2 > > > Just came across this. > The size estimation is: {{(limit + offset) * estimatedEntrySize}} > with just the passed limit and offset, and this estimate is applied for each > single scan. > This is way too pessimistic when a large limit is passed as just a safety > measure. > Assuming you pass 10.000.000. That is the overall limit, but Phoenix will > apply it to every scan (at least one per involved region) and take that much > memory of the pool. > Not sure what a better estimate would be. Ideally we'd divide by the number > of involved regions with some fuss, or use a size estimate of the region. -- This message was sent by Atlassian Jira (v8.3.4#803005)