Re: temporary file - No Space left on device

Ron <ronljohnsonjr@xxxxxxxxx> · Mon, 15 Feb 2021 07:45:57 -0600



    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 

          
              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
                  

    -- 

      Angular momentum makes the world go 'round.