Re: Index build temp files - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Index build temp files
Date
Msg-id 20130108221642.GD8789@momjian.us
Whole thread Raw
In response to Index build temp files  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Index build temp files
List pgsql-hackers
On Tue, Jan  8, 2013 at 05:09:47PM -0500, Stephen Frost wrote:
> Greetings,
> 
>   We were surprised recently to note that the temp files that are
>   created during a CREATE INDEX don't go into either a temp tablespace
>   set for the user or into the tablespace which the CREATE INDEX
>   specifies.  Instead, they go only into base/pgsql_tmp/.  This doesn't
>   allow for any flexibility in defining where to create these
>   potentially quite large sets of files.
> 
>   Shouldn't these temp files be going into the temp tablespace for the
>   user creating the index instead..?  Or perhaps into the tablespace
>   which the index is being created in?

Well, our docs for temp_tablespaces says:
       This variable specifies tablespaces in which to create temporary       objects (temp tables and indexes on temp
tables)when a       <command>CREATE</> command does not explicitly specify a tablespace.       Temporary files for
purposessuch as sorting large data sets       are also created in these tablespaces.
 

Are you saying this is inaccorate?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Improve compression speeds in pg_lzcompress.c
Next
From: Stephen Frost
Date:
Subject: Re: Re: Proposal: Store "timestamptz" of database creation on "pg_database"