pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
temporary file - No Space left on device
3+ messages / 2 participants
[nested] [flat]


* temporary file - No Space left on device
@ 2021-02-15 09:44 dbatoCloud Solution <dbatocloud17@gmail.com>
  2021-02-15 10:54 ` Re: temporary file - No Space left on device dbatoCloud Solution <dbatocloud17@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: dbatoCloud Solution @ 2021-02-15 09:44 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

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

Attachments:


image.png (image/png, 40.3K) download
  view image


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: temporary file - No Space left on device
  2021-02-15 09:44 temporary file - No Space left on device dbatoCloud Solution <dbatocloud17@gmail.com>
@ 2021-02-15 10:54 ` dbatoCloud Solution <dbatocloud17@gmail.com>
  2021-02-15 13:45   ` Re: temporary file - No Space left on device Ron <ronljohnsonjr@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: dbatoCloud Solution @ 2021-02-15 10:54 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

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@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: image.png]
>
>
>
> Regards,
> Ashok
>
>

Attachments:


image.png (image/png, 40.3K) download
  view image



image.png (image/png, 33.9K) download
  view image


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: temporary file - No Space left on device
  2021-02-15 09:44 temporary file - No Space left on device dbatoCloud Solution <dbatocloud17@gmail.com>
  2021-02-15 10:54 ` Re: temporary file - No Space left on device dbatoCloud Solution <dbatocloud17@gmail.com>
@ 2021-02-15 13:45   ` Ron <ronljohnsonjr@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Ron @ 2021-02-15 13:45 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

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) download
  view image



image.png (image/png, 40.3K) download
  view image


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2021-02-15 13:45 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-02-15 09:44 temporary file - No Space left on device dbatoCloud Solution <dbatocloud17@gmail.com>
2021-02-15 10:54 ` dbatoCloud Solution <dbatocloud17@gmail.com>
2021-02-15 13:45   ` Ron <ronljohnsonjr@gmail.com>

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