SYS.CREATE_ALL_BUCKETS

Pre-allocate buckets for partitioned table data.

Syntax

SYS.CREATE_ALL_BUCKETS()

By default, GemFire XD assigns partitioned table buckets to individual data store members lazily, as rows are inserted to a partitioned table. However, if you rapidly load data into a partitioned table using concurrent threads, data can be inserted to the table before new bucket assignments are distributed to available data stores. This can result in partitioned table data that is skewed among data stores in your cluster.

As a best practice, use SYS.CREATE_ALL_BUCKETS() before you load partitioned table data to ensure that the data is evenly distributed among available data stores.

Example

gfxd> call sys.create_all_buckets();