This topic describes the syntax of the HG_UPDATE_DATABASE_PROPERTY
function in Hologres.
Introduction
HG_UPDATE_DATABASE_PROPERTY
: modifies a property of a database. Currently, you can only call this function to
change the default number of shards contained in a table group.
Note To call the
HG_UPDATE_DATABASE_PROPERTY
function, you must be a superuser of the target Hologres instance or an owner of
the target database.
Parameters
- property: the name of the property to be modified.
- value: the value of the property after the modification.
Limitation
Only default shard_count of Table Group is supported.
Example
The following example changes the default number of shards contained in a table group to 120:
CALL HG_UPDATE_DATABASE_PROPERTY ( 'shard_count', '120' );