Index build temp files

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Index build temp files
Дата
Msg-id 20130108220947.GG16126@tamriel.snowman.net
обсуждение исходный текст
Ответы Re: Index build temp files  (Bruce Momjian <bruce@momjian.us>)
Список 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
temptablespace 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
offiles.
 
 Shouldn't these temp files be going into the temp tablespace for the user creating the index instead..?  Or perhaps
intothe tablespace which the index is being created in?
 
     Thanks,
    Stephen

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Re: Proposal: Store "timestamptz" of database creation on "pg_database"
Следующее
От: Tom Lane
Дата:
Сообщение: Re: I s this a bug of spgist index in a heavy write condition?