Skip to Content
0
Dec 22, 2022 at 11:52 AM

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

1467 Views

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