Re: Problem when temp_tablespace get full?

[Daniel Begin <jfd553@xxxxxxxxxxx>]

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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of David G. Johnston
Sent: June-03-15 11:54
To: Daniel Begin
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: Problem when temp_tablespace get full?

 

On Wed, Jun 3, 2015 at 11:14 AM, Daniel Begin <jfd553@xxxxxxxxxxx> 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.

​