Problem when temp_tablespace get full?

From: Daniel Begin <jfd553(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Problem when temp_tablespace get full?
Date: 2015-06-03 15:14:34
Message-ID: COL129-DS1037738D7D5793FDCF397094B40@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Context.

A query almost filled a SSD drive (temp_tablespace) and my PC got
unresponsive;

I did SELECT pg_cancel_backend(6600); 6600 was the pid of the process and
got a successful answer (t)

However, just after that, the disk simply turned off and the system crashed.

I was able to restart the PC - The SSD drive and the data are still there
but the drive keeps going off without warning.

I know I will have to change my drive!-)

But ma question is: What append the temp_tablespace drive get full?

Daniel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2015-06-03 15:54:28 Re: Problem when temp_tablespace get full?
Previous Message Robert Haas 2015-06-03 12:24:20 Re: [HACKERS] Re: 9.4.1 -> 9.4.2 problem: could not access status of transaction 1