[postgis-users] postgre tmp_tablespace

[P Adji]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090116/65cc6938/attachment.html>