> > > comments?> >> > Why not make it probabilistic by using, say, MyProcPid % n where nis the> > number of tablespaces? Then you don't need anything shared.
You still want a (local) counter, so that temp files for one session arespread out.
Andreas