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

From Daniel Begin
Subject Re: Problem when temp_tablespace get full?
Date
Msg-id COL129-DS206D2B4F69FF15164F75D094B40@phx.gbl
Whole thread Raw
In response to Re: Problem when temp_tablespace get full?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Problem when temp_tablespace get full?
List pgsql-general

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

 

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

 

 

David J.

pgsql-general by date:

Previous
From: Gmail
Date:
Subject: Re: Database designpattern - product feature
Next
From: Jan Lentfer
Date:
Subject: Re: Problem when temp_tablespace get full?