Feature signature for large spatio-temporal objects
The feature signature for large spatio-temporal objects is a storage optimization method provided by Ganos. This method stores the metadata of large spatio-temporal objects in-row and the object entity data off-row, reducing I/O overhead during spatio-temporal index creation and spatial join queries and improving processing performance.
Configure the GUC parameter
After you connect to the database, you can set the GUC parameter to enable or disable the storage optimization feature. The feature is disabled by default.
-
Enable
set polar_enable_storage_partial = true; -
Disable
set polar_enable_storage_partial = false;
Set the threshold
After you enable the storage optimization feature, an object is split into in-row and off-row storage only when the total size of the object in bytes exceeds the value of polar_partial_external_threshold.
The value range of polar_partial_external_threshold is 1000 to 8000. The default value is 2000. You can adjust this value before you create a table. Example:
set polar_partial_external_threshold = 3000;