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
