[Feature] Paimon dynamic bucket supports adding buckets based on storage size. #1816

Search before asking

• I searched in the issues and found nothing similar.

Motivation

The existing dynamic bucket solution is based on the data volume within each bucket to determine whether to add a new one. Due to the need to cache primary keys, when the table's data volume is large, more memory is required to support the dynamic bucket feature. It is hoped that the addition of buckets can be determined based on the storage size of the buckets, reducing the additional memory overhead.

Solution

By detecting whether the written bucket capacity reaches a threshold before adding new ones, it's also necessary to consider the scenario where the bucket capacity might decrease after bucket compaction.

Anything else?

No response

Are you willing to submit a PR?

• I'm willing to submit a PR!