Pedro Baldanta <pjbs39@tid.es> writes:
> PostgreSQL 8.0.1
> SunOS relayprod02 5.9 Generic_118558-19 sun4u sparc SUNW,Sun-Fire-V440
> -> Solaris 9 on Sparc processor.
> We are running java app over PostgreSQL. Everything works fine but we
> detected high semaphore usage during a heavy query process.
This sounds like a context swap storm ... search the archives for that
phrase, and then consider moving onto a more recent PG release.
regards, tom lane