Index build temp files

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Index build temp files
Date: 2013-01-08 22:09:47
Message-ID: 20130108220947.GG16126@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

Thanks,

Stephen

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2013-01-08 22:10:50 Re: I s this a bug of spgist index in a heavy write condition?
Previous Message Peter Eisentraut 2013-01-08 22:09:23 Re: Re: Proposal: Store "timestamptz" of database creation on "pg_database"