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' );