From acfce502ba1f79ff48c9376a4c113ee06b2674b8 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 3 Jun 2007 17:08:34 +0000 Subject: 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. --- src/backend/executor/execMain.c | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'src/backend/executor/execMain.c') diff --git a/src/backend/executor/execMain.c b/src/backend/executor/execMain.c index 298d0c69c9d..82b17b19f01 100644 --- a/src/backend/executor/execMain.c +++ b/src/backend/executor/execMain.c @@ -26,7 +26,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/executor/execMain.c,v 1.293 2007/04/27 22:05:47 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/executor/execMain.c,v 1.294 2007/06/03 17:07:00 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -2430,7 +2430,7 @@ OpenIntoRel(QueryDesc *queryDesc) get_namespace_name(namespaceId)); /* - * Select tablespace to use. If not specified, use default_tablespace + * Select tablespace to use. If not specified, use default tablespace * (which may in turn default to database's default). */ if (into->tableSpaceName) @@ -2444,7 +2444,7 @@ OpenIntoRel(QueryDesc *queryDesc) } else { - tablespaceId = GetDefaultTablespace(); + tablespaceId = GetDefaultTablespace(into->rel->istemp); /* note InvalidOid is OK in this case */ } -- cgit v1.2.3