Create a GUC parameter temp_tablespaces that allows selection of the
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 3 Jun 2007 17:08:34 +0000 (17:08 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 3 Jun 2007 17:08:34 +0000 (17:08 +0000)
commitacfce502ba1f79ff48c9376a4c113ee06b2674b8
treef10f42b5eff0e376f9738667d9efb868745c7d3c
parent5d429f8d88333d42072c371716d0345e12200fbc
Create a GUC parameter temp_tablespaces that allows selection of the
tablespace(s) in which to store temp tables and temporary files.  This is a
list to allow spreading the load across multiple tablespaces (a random list
element is chosen each time a temp object is to be created).  Temp files are
not stored in per-database pgsql_tmp/ directories anymore, but per-tablespace
directories.

Jaime Casanova and Albert Cervera, with review by Bernd Helmle and Tom Lane.
26 files changed:
doc/src/sgml/config.sgml
doc/src/sgml/manage-ag.sgml
doc/src/sgml/ref/create_index.sgml
doc/src/sgml/ref/create_table.sgml
doc/src/sgml/ref/create_table_as.sgml
doc/src/sgml/ref/drop_tablespace.sgml
doc/src/sgml/ref/grant.sgml
doc/src/sgml/storage.sgml
src/backend/commands/indexcmds.c
src/backend/commands/tablecmds.c
src/backend/commands/tablespace.c
src/backend/executor/execMain.c
src/backend/executor/nodeHash.c
src/backend/executor/nodeHashjoin.c
src/backend/storage/file/buffile.c
src/backend/storage/file/fd.c
src/backend/utils/misc/guc.c
src/backend/utils/misc/postgresql.conf.sample
src/backend/utils/sort/logtape.c
src/backend/utils/sort/tuplestore.c
src/include/commands/tablespace.h
src/include/executor/hashjoin.h
src/include/executor/nodeHashjoin.h
src/include/storage/buffile.h
src/include/storage/fd.h
src/include/utils/guc.h