Re: temporary file - No Space left on device

[dbatoCloud Solution <dbatocloud17@xxxxxxxxx>]

Hi All,

Just for your update,  the below temporary file size usage . Please let me know how to reduce this size

 

 

Thanks & Best Wishes,

Ashok

 

---------------------------------------------------------------------------------------------------------------------

Ashokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UAE | BLR , INDIA

M: +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922

W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@xxxxxxxxx

On Mon, Feb 15, 2021 at 3:14 PM dbatoCloud Solution <dbatocloud17@xxxxxxxxx> wrote:

Dear All,

 We have been facing temporary file - no space left issue on postgreSQL 10.13.

Please help

 

Error:touchstone.i131_core_contact_pref_center_unsub_0_9.I131_core_contact_pref_center_unsub - tDBRow_8 ERROR: could not write block 196055 of temporary file: No space left on device
org.postgresql.util.PSQLException: ERROR: could not write block 196055 of temporary file: No space left on device
approx IST time 2021-02-14 06:24:36

The below temporary file current usage#

Regards,

Ashok