<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
sorry my mistake, it should be temp_tablespaces. I use PG 8.3.0-1<BR><BR>> Date: Thu, 15 Jan 2009 09:00:09 -0800<BR>> From: kneufeld@refractions.net<BR>> To: postgis-users@postgis.refractions.net<BR>> Subject: Re: [postgis-users] postgre tmp_tablespace<BR>> <BR>> What version of PostgreSQL are you using? I don't see that variable in 8.3.<BR>> postgis=# show tmp_tablespace;<BR>> ERROR: unrecognized configuration parameter "tmp_tablespace"<BR>> <BR>> I would imagine it's the directory location for temporary files. According to the 8.3 docs:<BR>> "Temporary files (for operations such as sorting more data than can fit in memory) are created within <BR>> PGDATA/base/pgsql_tmp, or within a pgsql_tmp subdirectory of a tablespace directory if a tablespace other than <BR>> pg_default is specified for them. The name of a temporary file has the form pgsql_tmpPPP.NNN, where PPP is the PID of <BR>> the owning backend and NNN distinguishes different files of that backend."<BR>> <BR>> Cheers,<BR>> Kevin<BR>> <BR>> <BR>> P Adji wrote:<BR>> > Dear all,<BR>> > sorry if it is not postgis related.<BR>> > <BR>> > whats the variable tmp_tablespace in postgre is for ?<BR>> > <BR>> > thanks guys<BR>> > <BR>> > ------------------------------------------------------------------------<BR>> > Share your beautiful moments with Photo Gallery. Windows Live Photo <BR>> > Gallery <http://get.live.com/photogallery/overview><BR>> > <BR>> > <BR>> > ------------------------------------------------------------------------<BR>> > <BR>> > _______________________________________________<BR>> > postgis-users mailing list<BR>> > postgis-users@postgis.refractions.net<BR>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>> _______________________________________________<BR>> postgis-users mailing list<BR>> postgis-users@postgis.refractions.net<BR>> http://postgis.refractions.net/mailman/listinfo/postgis-users<BR><br /><hr />See all the ways you can stay connected <a href='http://www.microsoft.com/windows/windowslive/default.aspx' target='_new'>to friends and family</a></body>
</html>