pgsql_job_cache folder size grows unusually large

[nguoingoai]

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 ?

[emelsimsek]

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?

[nguoingoai]

I thinks some query was kill when it running, Can I delete these files without effecting the data ?

[emelsimsek]

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.