pg_cron icon indicating copy to clipboard operation
pg_cron copied to clipboard

Remove CacheInvalidateRelcacheByTuple and put CronJobCacheValid in shmem

Open fanfuxiaoran opened this issue 1 year ago • 2 comments

There is no need to call CacheInvalidateRelcacheByTuple when only updating the content of cron.job table( CacheInvalidateRelcacheByTuple should be called when the schema of crom.job udpated). Each time the CacheInvalidateRelcacheByTuple is called, the Relaion of pg_cron in launcher will be rebuilt which can lead some overhead.

Instead, put CronJobCacheValid into shmem, and set it to false in function InvalidateJobCache.

fanfuxiaoran avatar Dec 04 '23 05:12 fanfuxiaoran

@microsoft-github-policy-service agree [company="{your company}"]

fanfuxiaoran avatar Dec 04 '23 05:12 fanfuxiaoran

@microsoft-github-policy-service agree

fanfuxiaoran avatar Dec 04 '23 05:12 fanfuxiaoran

Closing this, since the current design seems to introduce bugs without solving a problem.

marcoslot avatar Aug 07 '24 19:08 marcoslot