> > > comments? > > > > Why not make it probabilistic by using, say, MyProcPid % n where n is the > > number of tablespaces? Then you don't need anything shared.
You still want a (local) counter, so that temp files for one session are spread out. Andreas ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend