This topic describes the functional modules that are provided by AliPG.

Overview

CategoryFunctional moduleDescription
Account permissionrds_superuserThe rds_superuser role is a type of intermediate account between standard accounts and superuser accounts. The accounts that are assigned the rds_superuser role are called privileged accounts. To ensure security on the cloud, AliPG does not provide superuser accounts. However, AliPG provides the rds_superuser role. The rds_superuser role does not have the sensitive security permissions that superuser accounts have. The rds_superuser role has the permissions to create and delete plug-ins, create and delete standard and privileged accounts, access and manage all of the tables that are created by standard accounts, and close connections.
GanosGanosGanos is a spatio-temporal database engine that is developed by Alibaba Cloud. Ganos provides a series of data types, functions, and stored procedures to efficiently store, index, query, analyze, and compute spatio-temporal data.
External data reads and writesoss_fdwThe oss_fdw plug-in supports data migration and hot and cold data separation. You can load data from Alibaba Cloud Object Storage Service (OSS) buckets to RDS instances. You can also write data from RDS instances to OSS buckets.
Concurrency control (CCL)pg_concurrency_controlThe pg_concurrency_control plug-in controls the concurrency of transactions, SQL queries, stored procedures, and data manipulation language (DML) operations. This plug-in allows you to customize large queries, which expedites the execution of highly concurrent workloads.
SQL throttlingrds_cclThe self-developed rds_ccl extension that is provided by AliPG can be used to perform SQL throttling. You can use SQL throttling to limit the maximum number of concurrent SQL statements to prevent excessive database loads, ensure database stability and reliability, and improve database performance and efficiency.
Failover slotFailover SlotIn open source PostgreSQL, logical slots cannot be automatically switched over to the new primary RDS instance in the event of a primary/secondary switchover. As a result, logical subscriptions are disconnected. In AliPG, the failover slot feature allows ApsaraDB RDS to synchronize all logical slots from the primary RDS instance to the secondary RDS instance. This prevents the disconnection of logical subscriptions.
Bitmap function extensionvarbitxThe varbit plug-in of open source PostgreSQL supports only simple BIT-type operation functions. The varbit plug-in is an extension of the varbit plug-in. The varbit plug-in is provided in AliPG to support more BIT-type operations in more scenarios. These scenarios include real-time user profile recommendation, access control advertising, and ticketing.
Vector searchPASEPASE is a high-performance vector search index plug-in that is developed for AliPG. The PASE plug-in uses IVFFlat and Hierarchical Navigable Small World (HNSW), which are well-developed, stable, and efficient approximate nearest neighbor (ANN) search algorithms. These algorithms are used to query vectors from PostgreSQL databases at high speeds. The PASE plug-in does not support the extraction or output of feature vectors. You must retrieve the feature vectors of the entities that you want to query. The PASE plug-in only implements a similarity search among a large number of vectors that are identified based on retrieved feature vectors.
Log querylog_fdwThe log_fdw plug-in queries logs from external tables.
Replication slot managementUse the WAL log management feature for an ApsaraDB RDS for PostgreSQL instanceAliPG allows you to delete inactive replication slots in the ApsaraDB RDS console or by calling API operations. This helps reduce the disk space that is used by WAL logs.
AvailabilityProtection levelsYou can set the protection level of an ApsaraDB RDS instance based on your business requirements. This setting allows you to improve the availability and performance of your RDS instance.
SecuritySecurity hardeningA security hardening module is built-in to improve custom views, enhance the security of the functions that you call, prevent security traps, and avoid the security vulnerabilities that are detected in open source PostgreSQL.

References

Extensions supported by ApsaraDB RDS for PostgreSQL