citusdata
pgsql_job_cache folder size grows unusually large
My Coordinator node have a folder pgsql_job_cache , recently size grows unusually large , this size is larger than folder data on this node . So what is the reason and how to fix this ?
Citus keeps intermediate result files in pgsql_job_cache folders. It may grow depending on your intermediate result sizes but should be cleaned-up after the queries are done. So when there is no running query it should not have anything in it. Do you observe otherwise?
I thinks some query was kill when it running, Can I delete these files without effecting the data ?
There was a few intermediate result file leak bugs, it is possible that you have run into them. What citus version are you on? And what are your schema/queries like?
As a workaround, If there is no query running at the moment, it should be fine to empty pgsql_job_cache folder.
Closing due to no response, please reopen if you still running into this issue with version details.
