Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group