Increase in CloudSQL Postgres instance temporary files (How to delete them?)

[Antonio Calo Chas]

There is an exponential increase in temporary files and they are not being released correctly. In Googlee Cloud SQL Postgres we do not have permissions to execute the pgsql_temp directory deletion.

Rebooting the machine is supposed to delete the base / pgsql_temp directory but it doesn't.

I can't stop the master either since it has an associated replica.

How can I force delete temporary files?

SELECT datname, temp_files AS "Temporary files", pg_size_pretty(temp_bytes) AS "Size of temporary files" FROM pg_stat_database;

(We can see in attach image the stoage and number of files)

Thanks a lot

[methkal]

Hi,

Can you please have a look at this solution https://stackoverflow.com/questions/39198380/delete-temporary-files-in-postgresql/39202367#39202367