Zeugswetter Andreas ADI SD wrote: > >> > > 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. >
Yes, but this can be used as a seed so not all backends start with the same counter value. cheers andrew ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend