Luis Amigo <lamigo(at)atc(dot)unican(dot)es> writes:
> We're getting similar problem.
> We're currently working on TPC-H benchmarking using postgresql 7.2b3.
> From one up to 8 paralell conexions (we've got 8 MIPS processors),
MIPS? Which spinlock implementation is getting used? (Look in
src/include/storage/s_lock.h and src/backend/storage/lmgr/s_lock.c)
If you're falling back to the default SysV-semaphore based spinlock
implementation, I wouldn't be surprised to see a performance problem...
regards, tom lane