Yandex Managed Service for Sharded PostgreSQL storage
Note
At the Preview stage, Managed Service for Sharded PostgreSQL does not use a storage, but you cannot create a cluster without one. You will need a storage later to aggregate data that does not fit into the RAM of the SPQRINFRA and SPQRROUTER hosts.
With Managed Service for Sharded PostgreSQL, you can use network storage drives to set up your cluster storage. Network drives are based on network blocks, which are virtual disks in the Yandex Cloud infrastructure.
Your storage can use the following disk types:
-
Network HDD (
network-hdd): Standard network drive; HDD network block storage. -
Network SSD (
network-ssd): Fast network drive; SSD network block storage.
Note
Up to 5% of disk space is reserved for system use, so the disks may have less available space than indicated when creating a cluster.
For more information about sizes and performance of different disk types, see the Yandex Compute Cloud documentation.
In Managed Service for Sharded PostgreSQL, the number of hosts you can create together with a cluster depends on the sharding type rather than on the selected disk type:
-
Standard sharding: One to seven
SPQRINFRAhosts. To ensure that your cluster is fault-tolerant, we recommend creating at least threeSPQRINFRAhosts in different availability zones. -
Advanced sharding:
- At least one
SPQRROUTERhost. The maximum number ofSPQRROUTERhosts is not limited. - At least five
SPQRCOORDINATORhosts. To ensure that such a cluster is fault-tolerant, we recommend creating threeSPQRCOORDINATORhosts in different availability zones.
- At least one