pg_cron | Run periodic jobs in PostgreSQL | Cron Utils library

We do schema-based multi-tenancy in our Postgres DB. Each and every schema is associated to a different tenant and will have the exact same structure except for one schema named public.

To obtain the list of all the relevant schemas, we can use:

I'm looking at turning for a very small postgres database (2 cores ver - 12.7) . Everything I have read so far says that the max_worker_processes should just be set to the number of cores allocated to postgres.

My question is, is there any harm to setting this above the number of cores?

Ultimately we're trying to use pg_cron with backend processes and for whatever reason pg_cron fails to launch a backend process if the max_worker_processes is set to less than 3.

We're considering updating max_worker_processes but we can't find any documentation or information that helps us know this won't cause other problems.

I have got two tables, 'page_visits' and 'comments', which store new webpage visits and new comments, respectively.

I want to aggregate the data from both the tables in the past 1 hour to use for analytics, such that it looks like the table below.

Postgres 13.4

I've got some pg_cron jobs set up to periodically delete older records out of log-like files. What I'd like to do is to run VACUUM ANALYZE after performing a purge. Unfortunately, I can't work out how to do this in a stored function. Am I missing a trick? Is a stored procedure more appropriate?

As an example, here's one of my purge routines

I'm writing up utility code to run through pg_cron, and sometimes want the routines to insert some results into a custom table at dba.event_log. I've got a basic log table as a starting point:

I'm working on getting pg_partman and pg_cron set up on RDS, but when my pg_cron jobs run, they return this error:

I have a plpgsql Procedure where I am simply trying to handle any possible exceptions, since I will be running these Procedures on pg_cron (automated) and I do not want anything to fail. The basic skeleton of the procedure looks like this:

• I am trying to install pg_cron on my local machine Big Sur M1 for development https://github.com/citusdata/pg_cron
• I cannot find any instructions on how to install this on M1
• sudo yum install -y pg_cron_12 does not work
• sudo apt-get -y install postgresql-12-cron doesnt work either
• My PostgreSQL version is 13.4, how do I install pg_cron

Aurora Postgress 12.6 Purpose: schedule to rebuild all indexes. what I did is create a function that calls all tables names and reindex concurrently and put the function in pg_cron but it gives me the error "SQL Error [25001]: ERROR: REINDEX CONCURRENTLY cannot be executed from a function". How can I archive the purpose?

Thanks