Postgres Pro
Downloads
Home   >   mailing lists

Re: temporary file - No Space left on device - Mailing list pgsql-admin

From Ron
Subject Re: temporary file - No Space left on device
Date
Msg-id 4d6828a5-ff5c-acd5-2ff5-49051b604021@gmail.com
Whole thread Raw
In response to Re: temporary file - No Space left on device  (dbatoCloud Solution <dbatocloud17@gmail.com>)
List pgsql-admin
Tree view
Some giant, poorly written query is running.

On 2/15/21 4:54 AM, dbatoCloud Solution wrote:
Hi All,
Just for your update,  the below temporary file size usage . Please let me know how to reduce this size

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/ | E: dbatocloud17@gmail.com



On Mon, Feb 15, 2021 at 3:14 PM dbatoCloud Solution <dbatocloud17@gmail.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.png



Regards,
Ashok


--
Angular momentum makes the world go 'round.
Attachment

pgsql-admin by date:

Previous
From: dbatoCloud Solution
Date:
Subject: Re: temporary file - No Space left on device
Next
From: Wells Oliver
Date:
Subject: Getting relevant table value as pertains to autovacuum_analyze_scale_factor (and vacuum scale factor)?