SAP BTP Postgresql pqsql_tmp - "No space left on device" error

[#1]

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

[Yogananda]

premchander

You need to increase the size of the <code>pg_tmp</code> directory. You can do this by editing the <code>postgresql.conf</code> file and setting the <code>temp_file_limit</code> parameter to a larger value. This parameter specifies the maximum amount of disk space (in bytes) that all temporary files can consume on a given database instance. You can also set the parameter to <code>-1</code>, which will allow temporary files to consume an unlimited amount of disk space.