so I guess for performance sake it makes sense do that under
$TABLESPACEPATH/yourdb/pgsql_tmp/ in case $TABLESPACEPATH for the object is being created is set to a non-default value
Temp files are created in $PGDATA/base/yourdb/pgsql_tmp/. If you have a mind to, you can replace that subdirectory with a symlink to a (suitably secure) directory elsewhere.
-- Vlad ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
