Chapter 16. Restarting pgpro_axe (duckdb.recycle_ddb)
You can restart the pgpro_axe columnar-vectorized analytics engine to apply its updated configuration parameters without restarting the current session. The updated configuration parameters apply only after the first executed analytical query.
Important
duckdb.recycle_ddb is a stored procedure reserved for troubleshooting, and it must not be used without supervision of a database engineer. The recommended way of applying updated pgpro_axe configuration parameters is restarting the current session.
Required privileges: Postgres Pro AXE administrator only. For more information about stored procedures and privileges, refer to Section 18.1.
Execute the following command on the Postgres Pro AXE server:
CALL duckdb.recycle_ddb();
Example 16.1. Executing the duckdb.recycle_ddb Stored Procedure and Updating pgpro_axe Configuration Parameters
SHOW duckdb.memory_limit;
SELECT * FROM duckdb.query(' SELECT current_setting(''memory_limit'') ');
CALL duckdb.recycle_ddb();
SET duckdb.memory_limit = 1024;
SELECT * FROM duckdb.query(' SELECT current_setting(''memory_limit'') ');