Re: Problem when temp_tablespace get full?

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?

Daniel

From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of David G. Johnston
Sent: June-03-15 11:54
To: Daniel Begin
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Problem when temp_tablespace get full?

On Wed, Jun 3, 2015 at 11:14 AM, Daniel Begin <jfd553(at)hotmail(dot)com> wrote:

A query

​OK...​

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

​The query, probably...

"There is also a temp_tablespaces parameter, which determines the placement of temporary tables and indexes, as well as temporary files that are used for purposes such as sorting large data sets."

http://www.postgresql.org/docs/9.4/static/manage-ag-tablespaces.html

David J.

​