From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: temporary file - No Space left on device
Date: Mon, 15 Feb 2021 07:45:57 -0600
Message-ID: <4d6828a5-ff5c-acd5-2ff5-49051b604021@gmail.com> (raw)
In-Reply-To: <CAEz7P_vB_iJfgK0P8e1jJ2KeQriPWA0XLmYphn9i5XA2aficYQ@mail.gmail.com>
References: <CAEz7P_tS7SFJCrP9rhVnh9kSGMr0+Jit0eTneHpTZaFdTqpoSw@mail.gmail.com>
<CAEz7P_vB_iJfgK0P8e1jJ2KeQriPWA0XLmYphn9i5XA2aficYQ@mail.gmail.com>
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/
> <http://dbatocloudsolution.blogspot.in/; | E: dbatocloud17@gmail.com
> <mailto:dbatocloud17@gmail.com>
>
>
>
> On Mon, Feb 15, 2021 at 3:14 PM dbatoCloud Solution
> <dbatocloud17@gmail.com <mailto: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.
Attachments:image.png (image/png, 33.9K) downloadview imageimage.png (image/png, 40.3K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: temporary file - No Space left on device
In-Reply-To: <4d6828a5-ff5c-acd5-2ff5-49051b604021@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox