Overview

1: Server Type
2: Monitoring Metrics

Service Overview

PostgreSQL(DBaaS) is an open-source relational database management system (RDBMS). Samsung Cloud Platform provides an environment that automates PostgreSQL installation and performs management functions for operation through a web-based Console.

PostgreSQL(DBaaS) is designed as a high availability architecture considering storage-based data replication and failover time minimization. To prevent data loss, when the content of the Active server changes, it is synchronously replicated to the Standby server. Read-only servers called Replica for read load distribution and disaster recovery (DR) are provided up to 5. Additionally, in preparation for problems with the DB server or data, it provides automatic backup at a time specified by the user, supporting data recovery at a desired point in time.

Provided Features

PostgreSQL(DBaaS) provides the following features.

Auto Provisioning: Database (DB) installation and configuration via UI, providing Active-Standby redundancy configuration based on storage replication. Automatic failover to Standby when Active server fails.
Operation Control Management: Provides function to control running server status. Start, stop, and restart possible for DB issues or to reflect configuration values. For HA configuration, users can directly perform Active-Standby node switching through Switch-over.
Backup and Recovery: Provides data backup function based on own backup commands. Backup time period and retention period can be set by user, and additional charges are incurred depending on backup capacity. Also provides recovery function for backed up data, where user performs recovery and separate DB is created, recovery proceeds to point in time selected by user (backup storage point, user-specified point). When recovering to user-specified point, recovery point can be set up to 5 minutes/10 minutes/30 minutes/1 hour before current time based on stored backup files and archive files.
Version Management: Provides version upgrade (Minor) function for some feature improvements and security patches. User can select whether to perform backup according to version upgrade, and if performing backup, backs up data before patch execution then performs DB engine update.
Replica Configuration: Can configure up to 5 Read Replicas in same/different regions for read load distribution and disaster recovery (DR).
Audit Settings: Supports audit function for major activities in database.
Parameter Management: Can modify DB configuration parameters for performance improvement and security.
Service Status Check: Checks final status of current DB service.
Monitoring: Can check CPU, memory, DB performance monitoring information through Cloud Monitoring service.
DB User Management: Manages DB account (user) information registered in DB.
DB Access Control Management: Can register and cancel access-allowed IPs based on DB accounts registered in DB.
Archive Management: Can set Archive file retention period (1~35 days) and Archive mode (On/Off) in DB server.
DB Log Export: Can export logs stored through Audit settings to user’s Object Storage.
Migration: Supports migration using replication method by synchronizing data with operating database in real time without service interruption.
OS Kernel Upgrade: Can upgrade OS Kernel for some feature improvements and security patch application.

Components

PostgreSQL(DBaaS) provides pre-verified engine versions and various server types according to open source support policy. Users can select and use according to the service scale they want to configure.

Engine Versions

Engine versions supported by PostgreSQL(DBaaS) are as follows.

Technical support can be used until the supplier’s EoTS (End of Technical Service) date, and the EOS date when new creation stops is set to 6 months before the EoTS date.

EOS and EoTS dates may change according to supplier policy, so please refer to the supplier’s license management policy page for details.

PostgreSQL: https://www.postgresql.org/support/versioning/

Provided Version	EOS Date (Samsung Cloud Platform New Creation Stop Date)	EoTS Date (Community Technical Support End Date)
14.17	2026-07 (Scheduled)	2026-11-12
14.18	2026-07 (Scheduled)	2026-11-12
15.12	2027-06 (Scheduled)	2027-11-11
15.13	2027-06 (Scheduled)	2027-11-11
15.14	2027-06 (Scheduled)	2027-11-11
16.8	2028-06 (Scheduled)	2028-11-09
16.9	2028-06 (Scheduled)	2028-11-09
16.10	2028-06 (Scheduled)	2028-11-09
17.6	2029-06 (Scheduled)	2029-11-08

Table. PostgreSQL(DBaaS) Provided Engine Versions

Server Type

Server types supported by PostgreSQL(DBaaS) are as follows.

For details on server types provided by PostgreSQL(DBaaS), see PostgreSQL(DBaaS) Server Type.

Standard db1v2m4

Category	Example	Detailed Description
Server Type	Standard	Provided server types Standard: Standard specifications (vCPU, Memory) generally used High Capacity: Large capacity server specifications with 24vCore or more
Server Specification	db1	Provided server specifications db1: Standard specifications (vCPU, Memory) generally used dbh2: Large capacity server specifications Provides servers with 24 vCore or more
Server Specification	v2	vCore count v2: 2 virtual cores
Server Specification	m4	Memory capacity m4: 4GB Memory

Table. PostgreSQL(DBaaS) Server Type Components

Prerequisite Services

List of services that must be configured in advance before creating this service. For details, please prepare in advance by referring to the guide provided for each service.

Service Category	Service	Detailed Description
Networking	VPC	Service that provides independent virtual network in cloud environment

Table. PostgreSQL(DBaaS) Prerequisite Services

1 - Server Type

PostgreSQL(DBaaS) server type

PostgreSQL(DBaaS) provides a server type composed of various combinations such as CPU, Memory, Network Bandwidth. When creating PostgreSQL(DBaaS), the Database Engine is installed according to the server type selected for the purpose of use.

The server types supported by PostgreSQL(DBaaS) are as follows.

Standard db1v2m4

Classification	Example	Detailed Description
Server Type	Standard	Provided server type distinction Standard: Composed of standard specifications (vCPU, Memory) commonly used High Capacity: Server specifications with higher capacity than Standard
Server specification	db1	Provided server type distinction and generation db: means general specification, and 1 means generation dbh: h means large-capacity server specification, and 2 means generation
Server specification	v2	Number of vCores v2: 2 virtual cores
Server specification	m4	Memory capacity m4: 4GB Memory
Fig. PostgreSQL(DBaaS) server type format

db1 server type

The db1 server type of PostgreSQL(DBaaS) is provided with standard specifications(vCPU, Memory) and is suitable for various database workloads.

Up to 3.3Ghz Intel 3rd generation (Ice Lake) Xeon Gold 6342 Processor Supports up to 16 vCPUs and 256 GB of memory Up to 12.5 Gbps of networking speed

Classification	Server Type	vCPU	Memory	Network Bandwidth
Standard	db1v2m4	2 vCore	4 GB	Up to 10 Gbps
Standard	db1v2m8	2 vCore	8 GB	Up to 10 Gbps
Standard	db1v2m16	2 vCore	16 GB	Up to 10 Gbps
Standard	db1v2m24	2 vCore	24 GB	Up to 10 Gbps
Standard	db1v2m32	2 vCore	32 GB	Up to 10 Gbps
Standard	db1v4m8	4 vCore	8 GB	Up to 10 Gbps
Standard	db1v4m16	4 vCore	16 GB	Up to 10 Gbps
Standard	db1v4m32	4 vCore	32 GB	Up to 10 Gbps
Standard	db1v4m48	4 vCore	48 GB	Up to 10 Gbps
Standard	db1v4m64	4 vCore	64 GB	Up to 10 Gbps
Standard	db1v6m12	6 vCore	12 GB	Up to 10 Gbps
Standard	db1v6m24	6 vCore	24 GB	Up to 10 Gbps
Standard	db1v6m48	6 vCore	48 GB	Up to 10 Gbps
Standard	db1v6m72	6 vCore	72 GB	Up to 10 Gbps
Standard	db1v6m96	6 vCore	96 GB	Up to 10 Gbps
Standard	db1v8m16	8 vCore	16 GB	Up to 10 Gbps
Standard	db1v8m32	8 vCore	32 GB	Up to 10 Gbps
Standard	db1v8m64	8 vCore	64 GB	Up to 10 Gbps
Standard	db1v8m96	8 vCore	96 GB	Up to 10 Gbps
Standard	db1v8m128	8 vCore	128 GB	Up to 10 Gbps
Standard	db1v10m20	10 vCore	20 GB	Up to 10 Gbps
Standard	db1v10m40	10 vCore	40 GB	Up to 10 Gbps
Standard	db1v10m80	10 vCore	80 GB	Up to 10 Gbps
Standard	db1v10m120	10 vCore	120 GB	Up to 10 Gbps
Standard	db1v10m160	10 vCore	160 GB	Up to 10 Gbps
Standard	db1v12m24	12 vCore	24 GB	Up to 12.5 Gbps
Standard	db1v12m48	12 vCore	48 GB	Up to 12.5 Gbps
Standard	db1v12m96	12 vCore	96 GB	Up to 12.5 Gbps
Standard	db1v12m144	12 vCore	144 GB	Up to 12.5 Gbps
Standard	db1v12m192	12 vCore	192 GB	Up to 12.5 Gbps
Standard	db1v14m28	14 vCore	28 GB	Up to 12.5 Gbps
Standard	db1v14m56	14 vCore	56 GB	Up to 12.5 Gbps
Standard	db1v14m112	14 vCore	112 GB	Up to 12.5 Gbps
Standard	db1v14m168	14 vCore	168 GB	Up to 12.5 Gbps
Standard	db1v14m224	14 vCore	224 GB	Up to 12.5 Gbps
Standard	db1v16m32	16 vCore	32 GB	Up to 12.5 Gbps
Standard	db1v16m64	16 vCore	64 GB	Up to 12.5 Gbps
Standard	db1v16m128	16 vCore	128 GB	Up to 12.5 Gbps
Standard	db1v16m192	16 vCore	192 GB	Up to 12.5 Gbps
Standard	db1v16m256	16 vCore	256 GB	Up to 12.5 Gbps

Table. PostgreSQL(DBaaS) server type specifications - db1 server type

dbh2 server type

The dbh2 server type of PostgreSQL(DBaaS) is provided with large-capacity server specifications and is suitable for database workloads for large-scale data processing.

Up to 3.2GHz Intel 4th generation (Sapphire Rapids) Xeon Gold 6448H Processor Supports up to 128 vCPUs and 1,536 GB of memory Up to 25Gbps of networking speed

Classification	Server Type	vCPU	Memory	Network Bandwidth
High Capacity	dbh2v24m48	24 vCore	48 GB	Up to 25 Gbps
High Capacity	dbh2v24m96	24 vCore	96 GB	Up to 25 Gbps
High Capacity	dbh2v24m192	24 vCore	192 GB	Up to 25 Gbps
High Capacity	dbh2v24m288	24 vCore	288 GB	Up to 25 Gbps
High Capacity	dbh2v32m64	32 vCore	64 GB	Up to 25 Gbps
High Capacity	dbh2v32m128	32 vCore	128 GB	Up to 25 Gbps
High Capacity	dbh2v32m256	32 vCore	256 GB	Up to 25 Gbps
High Capacity	dbh2v32m384	32 vCore	384 GB	Up to 25 Gbps
High Capacity	dbh2v48m192	48 vCore	192 GB	Up to 25 Gbps
High Capacity	dbh2v48m576	48 vCore	576 GB	Up to 25 Gbps
High Capacity	dbh2v64m256	64 vCore	256 GB	Up to 25 Gbps
High Capacity	dbh2v64m768	64 vCore	768 GB	Up to 25 Gbps
High Capacity	dbh2v72m288	72 vCore	288 GB	Up to 25 Gbps
High Capacity	dbh2v72m864	72 vCore	864 GB	Up to 25 Gbps
High Capacity	dbh2v96m384	96 vCore	384 GB	Up to 25 Gbps
High Capacity	dbh2v96m1152	96 vCore	1152 GB	Up to 25 Gbps
High Capacity	dbh2v128m512	128 vCore	512 GB	Up to 25 Gbps
High Capacity	dbh2v128m1536	128 vCore	1536 GB	Up to 25 Gbps

Table. PostgreSQL(DBaaS) server type specifications - dbh2 server type

2 - Monitoring Metrics

PostgreSQL(DBaaS) Monitoring Metrics

The following table shows the performance monitoring metrics of PostgreSQL(DBaaS) that can be checked through Cloud Monitoring. For detailed instructions on using Cloud Monitoring, refer to the Cloud Monitoring guide.

For server monitoring metrics of PostgreSQL(DBaaS), refer to the Virtual Server Monitoring Metrics guide.

Performance Item	Detailed Description	Unit
Active Locks	Number of Active Locks	cnt
Active Locks [Access Exclusive]	Number of Access Exclusive Locks	cnt
Active Locks [Access Share]	Number of Access Share Locks	cnt
Active Locks [Total]	Total Number of Active Locks	cnt
Active Sessions	Number of Active Sessions	cnt
Active Sessions [Total]	Total Number of Active Sessions	cnt
Apply Lag Time	Apply Lag Time	min
Check No Replication	Check No Replication Value	cnt
Check Replication	Check Replication Status Value	status
Connection Usage	DB Connection Usage Rate (%)	%
Connection Usage [Total]	DB Connection Usage Rate (%)	%
DB Age Max	Database Age (Frozen XID) Value	age
Exclusive Locks	Number of Exclusive Locks	cnt
Idle In Transaction Sessions	Number of Idle In Transaction Sessions	cnt
Idle In Transaction Sessions [Total]	Total Number of Idle In Transaction Sessions	cnt
Idle Sessions	Number of Idle Sessions	cnt
Idle Sessions [Total]	Total Number of Idle Sessions	cnt
Row Exclusive Locks	Number of Row Exclusive Locks	cnt
Row Share Locks	Number of Row Share Locks	cnt
Share Locks	Number of Share Locks	cnt
Share Row Exclusive Locks	Number of Share Row Exclusive Locks	cnt
Share Update Exclusive Locks	Number of Share Update Exclusive Locks	cnt
Slowqueries	Number of Long-Running SQL Queries (over 5 minutes)	cnt
Tablespace Used	Table Space Size	bytes
Tablespace Used [Total]	Table Space Size	bytes
Tablespace Used Bytes [MB]	File System Directory Usage (MB)	MB
Tablespaces [Total]	File System Directory Usage (MB)	MB
Transaction Time Max [Long]	Longest Running Transaction Time (minutes)	min
Transaction Time Max Total [Long]	Longest Running Transaction Time (minutes)	min
Wait Locks	Number of Sessions Waiting for Locks (per DB)	cnt
Wait Locks [Long Total]	Number of Sessions Waiting for Locks for a Long Time (over 300 seconds)	cnt
Wait Locks [Long]	Number of Sessions Waiting for Locks	cnt
Wait Locks [Total]	Total Number of Sessions Waiting for Locks	cnt
Waiting Sessions	Number of Waiting Sessions	cnt
Waiting Sessions [Total]	Total Number of Waiting Sessions	cnt

Table. PostgreSQL(DBaaS) Monitoring Metrics