Back to Cron Helper
Recipedatabasepostgresmaintenanceoptimization

PostgreSQL Vacuum Analyze

Automate PostgreSQL database maintenance with VACUUM ANALYZE.

Over time, PostgreSQL tables accumulate dead rows and statistics become outdated. Running `VACUUM ANALYZE` reclaims storage and updates the query planner statistics, ensuring your database queries remain fast and efficient.

Cron Schedule

Every Monday0 0 * * 1
Runs every Monday at 00:00 (midnight).
Learn more about Every Monday

Command to Run

Copy and paste this command into your crontab or automation script

psql -U username -d dbname -c "VACUUM ANALYZE;"
This command will run according to the cron schedule above.

Implementation Examples

Here are code examples for implementing this cron job in different programming languages:
Unix/Linux Crontab
0 0 * * 1 /path/to/script.sh
Python (with schedule library)
schedule.every().monday.do(job)
Node.js (with node-cron)
cron.schedule('0 0 * * 1', () => {
  console.log('Running every Monday');
});
Go (with robfig/cron)
c.AddFunc("0 0 * * 1", func() { fmt.Println("Run every Monday") })
GitHub Actions Workflow
- cron: "0 0 * * 1"

Related Cron Recipes

Automate PostgreSQL Backups Daily

How to schedule a daily PostgreSQL database backup using cron.
databasepostgresbackup
View Recipe

Automate MySQL Backups Daily

Schedule a daily MySQL database dump using cron.
databasemysqlbackup
View Recipe

Automate MongoDB Backups Daily

How to schedule a daily MongoDB backup using cron.
databasemongodbbackup
View Recipe

Automate Redis RDB Snapshots

Schedule a Redis background save (snapshot) via cron.
databaserediscache
View Recipe

Sync Folder to AWS S3

Cron job to sync local files to an AWS S3 bucket.
awscloudbackup
View Recipe

Rsync Incremental Backup

Schedule secure, incremental backups using rsync.
linuxbackupnetwork
View Recipe