Latest Articles
- Hacking the Postgres Statistics Tables for Faster Queries
- OpenTelemetry Observability in Crunchy Postgres for Kubernetes
- Creating Histograms with Postgres
- Introducing Crunchy Postgres for Kubernetes 5.8: OpenTelemetry, API enhancements, UBI-9 and More
- Crunchy Data Warehouse: Postgres with Iceberg Available for Kubernetes and On-premises
Announcing the Scheduler for Crunchy Bridge
1 min readMore by this author
Today we're excited to announce a new scheduler for Crunchy Bridge. Scheduler makes it easy for you to create and manage automated database maintenance tasks such as:
- Refreshing materialized views
- Performing automated roll-ups from raw data
- Running partitioning maintenance tasks (run pg_partman automatically)
- Archiving or pruning old data
Scheduler under the covers leverages pg_cron, this means any cron jobs you've already created are automatically available to you. With scheduler you no longer need to manage or configure pg_cron directly, now you have a straightforward interface for controlling when your scheduled job is run and managing it.
Scheduler is available today on all clusters within our fully managed Postgres, Crunchy Bridge. You can set time intervals within days, weeks, months or years. Simply navigate to the scheduler from within your cluster view in the dashboard. Enter your SQL statement and the task the time interval, and we'll take of the rest.
Related Articles
- Hacking the Postgres Statistics Tables for Faster Queries
13 min read
- OpenTelemetry Observability in Crunchy Postgres for Kubernetes
8 min read
- Creating Histograms with Postgres
10 min read
- Introducing Crunchy Postgres for Kubernetes 5.8: OpenTelemetry, API enhancements, UBI-9 and More
4 min read
- Crunchy Data Warehouse: Postgres with Iceberg Available for Kubernetes and On-premises
6 min read