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-ow...@postgresql.org [mailto:pgsql-general-ow...@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 <jfd...@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." http://www.postgresql.org/docs/9.4/static/manage-ag-tablespaces.html David J.
