Re: Problem when temp_tablespace get full? - Mailing list pgsql-general

From Jan Lentfer
Subject Re: Problem when temp_tablespace get full?
Date
Msg-id b51f95d7efdab143608e0bb236535646@imap.lan.net
Whole thread Raw
In response to Re: Problem when temp_tablespace get full?  (Daniel Begin <jfd553@hotmail.com>)
List pgsql-general
Am 2015-06-03 19:00, schrieb Daniel Begin:
> Sorry, my question might not have been clear…
>
> I set myself the temp_tablespace to that location but did not expect
> the drive could get full;
>
> Multiple factors may have caused the drive to turn off (not
> necessarily postgresql);
>
> So, if that temp_tablespace gets full, how postgresql will
> react/manage the situation?

Queries running out of space in pgsql_tmp will just cancel (and
rollback).

Jan


pgsql-general by date:

Previous
From: Daniel Begin
Date:
Subject: Re: Problem when temp_tablespace get full?
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] Re: 9.4.1 -> 9.4.2 problem: could not access status of transaction 1