[postgis-users] postgre tmp_tablespace

[Kevin Neufeld]

http://www.postgresql.org/docs/8.3/static/runtime-config-client.html#GUC-TEMP-TABLESPACES


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