Storage in Yandex Managed Service for Sharded PostgreSQL
With Managed Service for Sharded PostgreSQL, you can use network disks and local disks to set up a cluster storage. Network disks are based on network blocks, i.e., 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 this Yandex Compute Cloud guide.
Managed Service for Sharded PostgreSQL allows you to use local storage for database clusters. Local drives are physically located on the database host servers.
To create a cluster, you use local SSDs (local-ssd), which are the highest-performing disks. The minimum storage size is 10 GB; the maximum, 20 GB.
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
INFRAhosts. To ensure that your cluster is fault-tolerant, we recommend creating at least threeINFRAhosts in different availability zones. -
Advanced sharding:
- From 1 to 100
ROUTERhosts. To ensure that your cluster is fault-tolerant, we recommend creating at least threeROUTERhosts in different availability zones. - From one to three
COORDINATORhosts. To ensure that such a cluster is fault-tolerant, we recommend creating threeCOORDINATORhosts in different availability zones.
- From 1 to 100