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