Functional modules of AliPG
Updated at:
AliPG extends standard PostgreSQL with purpose-built modules for account management, geospatial processing, external storage integration, concurrency control, high availability, and security. Use the table below to find the module that matches your use case, then follow the link for configuration details.
Modules
| Category | Module | Description |
|---|---|---|
| Account permission | rds_superuser | The rds_superuser role sits between standard accounts and superuser accounts. Accounts assigned this role are called privileged accounts. Because AliPG does not provide superuser accounts for security reasons, rds_superuser gives privileged accounts the ability to create and delete extensions, create and delete standard and privileged accounts, access and manage all tables created by standard accounts, and close connections — without the sensitive permissions that a superuser carries. |
| GanosBase | GanosBase | GanosBase is a spatio-temporal database engine developed by Alibaba Cloud. It provides data types, functions, and stored procedures for storing, indexing, querying, analyzing, and computing spatio-temporal data. |
| External data reads and writes | oss_fdw | The oss_fdw extension supports data migration and hot and cold data separation. Load data from Object Storage Service (OSS) buckets into RDS instances, or write data from RDS instances to OSS buckets. |
| Concurrency control (CCL) | pg_concurrency_control | The pg_concurrency_control extension controls the concurrency of transactions, SQL queries, stored procedures, and data manipulation language (DML) operations. It lets you customize large queries to speed up highly concurrent workloads. |
| SQL throttling | rds_ccl | The rds_ccl extension limits the maximum number of concurrent SQL statements. Use it to prevent excessive database load and maintain stability and performance under traffic spikes. |
| Failover slot | Failover Slot | In open-source PostgreSQL, logical replication slots are not automatically transferred during a primary/secondary switchover, which breaks logical subscriptions. AliPG's Failover Slot feature keeps all logical replication slots in sync between the primary and secondary RDS instances, so logical subscriptions remain connected after a switchover. |
| Bitmap function extension | varbitx | The varbitx extension adds BIT-type operations beyond what the built-in varbit type supports. Common use cases include real-time user profile recommendations, access control for advertising, and ticketing systems. |
| Vector search | PASE | PASE is a high-performance vector search index extension built for AliPG. It implements IVFFlat and Hierarchical Navigable Small World (HNSW) algorithms for approximate nearest neighbor (ANN) search across large vector sets stored in PostgreSQL. PASE performs similarity search on vectors you supply — it does not support the extraction or output of feature vectors from source data. |
| Log query | log_fdw | The log_fdw extension queries logs from external tables. |
| Replication slot management | WAL log management | Delete inactive replication slots from the ApsaraDB RDS console or via API to reclaim disk space consumed by write-ahead log (WAL) data. |
| Availability | Protection levels | Set the protection level of an ApsaraDB RDS instance based on your business requirements to improve the availability and performance of your RDS instance. |
| Security | Security hardening | A built-in security hardening module improves custom view handling, strengthens the security of called functions, prevents security traps, and closes vulnerabilities present in open-source PostgreSQL. |
Related topics
Is this page helpful?