Re: temporary file - No Space left on device

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

[image: image.png]

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/
<http://dbatocloudsolution.blogspot.in/> | E: dbatocloud17(at)gmail(dot)com

On Mon, Feb 15, 2021 at 3:14 PM dbatoCloud Solution <dbatocloud17(at)gmail(dot)com>
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#*
> [image: image.png]
>
>
>
> Regards,
> Ashok
>
>