Managing extensions

PostgreSQL extensions enhance database functionality by adding features such as advanced indexing, data types, and performance optimizations. This guide explains how to manage extensions in your RayDB cluster.

Listing Available Extensions

To see a list of available extensions in your RayDB cluster, run:

SELECT * FROM pg_available_extensions;

Installing an Extension

To enable an extension for your database, use the CREATE EXTENSION command:

CREATE EXTENSION IF NOT EXISTS extension_name;

Example:

CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

Viewing Installed Extensions

To check which extensions are currently installed, use:

SELECT * FROM pg_extension;

Removing an Extension

To remove an extension that is no longer needed, use:

DROP EXTENSION IF EXISTS extension_name;

Example:

DROP EXTENSION IF EXISTS hstore;

Best Practices

• Enable only necessary extensions to avoid unnecessary resource usage.
• Check compatibility before enabling extensions, especially after PostgreSQL upgrades.
• Monitor extension impact on database performance using built-in PostgreSQL monitoring tools.

For more details on enabling extensions, see Enabling Extensions.