[google-cloud-sql-discuss] Re: Increase in CloudSQL Postgres instance temporary files (How to delete them?)

Hi,

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

On Wednesday, February 24, 2021 at 11:40:14 AM UTC+1 anto...@gmail.com wrote:

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

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/fb472ce7-5f48-4b52-a908-3cbd3c9d79cen%40googlegroups.com.