When you run a complex query and want to quickly obtain query results, you can use the rds_duckdb extension of ApsaraDB RDS for PostgreSQL to implement analytical processing (AP) query acceleration. This extension exports local tables as column-oriented tables and uses vectorization capabilities to significantly accelerate complex queries without the need to modify original query statements. This allows you to obtain the query results in a convenient and efficient manner.
Overview
The rds_duckdb extension of ApsaraDB RDS for PostgreSQL is developed based on DuckDB, which is efficient and resource-friendly. This extension enhances analytical query capabilities. You can use the extension to export the local tables of an ApsaraDB RDS for PostgreSQL instance as column-oriented tables and enable the AP query acceleration feature. This significantly accelerates complex queries to meet the requirements of analytical services.
Effective date
September 27, 2024
The rds_duckdb extension is available for users in the whitelist. If you want to use the extension, contact us.
Prerequisites
The RDS instance runs PostgreSQL 16.
The RDS instance runs a minor engine version of 20240830 or later.
The
shared_preload_librariesparameter is set to'rds_duckdb'. For more information about how to configure parameters, see Modify the parameters of an ApsaraDB RDS for PostgreSQL instance.
Usage notes
You cannot synchronize the data of column-oriented tables between the primary and secondary RDS instances.
You cannot export the data of column-oriented tables to implement automatic incremental synchronization.
References
For more information about the usage and examples of the rds_duckdb extension, see Use the rds_duckdb extension to accelerate AP queries.