Posted On: Jun 17, 2021
Amazon Aurora PostgreSQL-Compatible Edition adds support for the pg_cron extension. pg_cron allows you to use cron syntax to schedule PostgreSQL commands directly within your database. You can use pg_cron to schedule tasks such as periodically rolling up data for analytic reports, refreshing materialized views, and scheduling vacuum jobs to reclaim storage. pg_cron includes an AWS open source contribution that adds an audit table so that you can query the outcome of each scheduled job.
Please review the Aurora documentation to learn more. You can view a list of all PostgreSQL extensions supported on RDS on the AWS User Guide.
Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to three times better performance than the typical PostgreSQL database, together with increased scalability, durability, and security. For more information, please visit the Amazon Aurora product page. To get started with Amazon Aurora PostgreSQL, take a look at our getting started page.
Don't see an extension you'd like to use? Let us know through the AWS Forum, through AWS Enterprise support, or by emailing us at rds-postgres-extensions-request@amazon.com.