Feature signature-based storage optimization for large spatio-temporal objects - PolarDB

The feature signatures of large spatio-temporal objects are used in GanosBase to optimize the storage of these objects. This storage optimization feature allows you to store the metadata of these objects in-row and store the entity data of these objects off-row. This increases processing performance and reduces I/O overhead in scenarios such as spatio-temporal index creation and spatial joins.

Configure the storage optimization feature

After you connect to your PolarDB cluster, you can enable or disable the storage optimization feature by using a Grand Unified Configuration (GUC) parameter. By default, the storage optimization feature is disabled.

To enable the storage optimization feature, run the following command:
```
set polar_enable_storage_partial = true;
```
To disable the storage optimization feature, run the following command:
```
set polar_enable_storage_partial = false;
```

Configure the threshold for storage optimization

After you enable the storage optimization feature, PolarDB implements in-row storage and off-row storage on a large spatio-temporal object only when the number of bytes for the object exceeds the value of the polar_partial_external_threshold parameter.

The value of the polar_partial_external_threshold parameter ranges from 1000 to 8000. The default value is 2000. Before you create a table, you can reconfigure this parameter. Example:

set polar_partial_external_threshold = 3000;