Hello Everyone,
I have been currently using Postgresql-db (Standard Plan) for my production environment.
Recently I have got the following error "could not write to file "base/pgsql_tmp/pgsql_tmp15298.0": No space left on device" when accessing one of the table with select query.
Seems like pg_tmp space is not available. When I checked the database, the temp files is getting created on the base/pgsql_tmp folder. So can anyone guide me in resolving the issue
Below are the queries,
How to clear the pgsql_tmp temporary files in SAP BTP postgresql-db?
How to prevent the DB from getting created pg_tmp files in postgresql-db?
Looking for your suggestions.
Thanks,
Prem