citusdata / citusdata/pg_cron

CALL running slower via cron job

Open
#245 2 comments 1 reaction 0 assignees View on GitHub
Dominant language
C
Stars
3.9k
Forks
260
Avg merge
5d 5h
Merged PRs (30d)
1

Description

I have a fairly straightforward stored procedure that runs and completes within ~2 minutes typically when it's called manually. I have the same call being made via pg_cron and it takes significantly longer (last run was 48 minutes).

I've turned the job off and run manually again and still a solid ~2 minutes on multiple runs. Are there additional resources or anything that need to be put in place?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.