Not sure how I managed to interchange Greg's reply and my response, but here's mine again:
Thanks, I figured that, but was hoping otherwise. I realize that the timing would make it unlikely, but unfortunately I
need100% guaranteed. I have an alternative in that I control the accessing clients (my app) and can apply a lock to
preventit from happening.
I found the average select nextval() call was taking 2ms, which seems a bit slow to me. Throw in the fsync I suppose
andthat'd explain it.
Interestingly, in the tests I ran the minimum select nextval() was 400us, and the max was 35ms, with an average of 2ms.
Thiswas on a DL380 dual 2.4G processors, 2.5G RAM, 5x10k SCSI drives, and no load - pretty much idle (well, a processes
checkingfor entries in a command table 10 times per second).
Oscar
_____________________________________________________________
The BMW E30 community on the web---> http://www.bmwe30.net