Skip to content

Instantly share code, notes, and snippets.

@k-caps

k-caps/compare.csv

Last active April 2, 2024 10:31
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save k-caps/27f9e4f3504a974ee14bb8f8762f68ef to your computer and use it in GitHub Desktop.
Save k-caps/27f9e4f3504a974ee14bb8f8762f68ef to your computer and use it in GitHub Desktop.
Download ZIP
pg agent vs pg cron
Raw
compare.csv
pg_cron pgAGent
GUI no yes
CLI yes no
Complex scheduling Standard crontab; one cron entry per execution (of command [sql or plpgsql] or.sql file Multiple steps per entry; multiple schedules for the same step without duplicating it
Requires extra software extension in shared_preload_libraries; installed via yum or similar pgAdmin is required to manage jobs; installed via yum or similar; runs as a separate daemon
Runs inside the database yes Jobs are stored in the database but are managed externally via pgAdmin; scheduling is run via the external daemon
Can be run without sSQL knowledge no yes
Requires Postgres cluster restart yes no
@TarikKaanKoc
Copy link

thanks for sharing!

@somerongit
Copy link

Thanks for the brief comparison...

@pea-sys
Copy link

pea-sys commented Oct 26, 2023

Thank you for making it easy to understand

@wangdenis
Copy link

Clear, thank you

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment