Re: Problem when temp_tablespace get full?

From: Jan Lentfer <Jan(dot)Lentfer(at)web(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem when temp_tablespace get full?
Date: 2015-06-03 17:17:31
Message-ID: b51f95d7efdab143608e0bb236535646@imap.lan.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2015-06-03 17:26:02 Re: Re: [GENERAL] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1
Previous Message Daniel Begin 2015-06-03 17:00:06 Re: Problem when temp_tablespace get full?