Using PGSQL to help coordinate many servers

Hi,

We have a need to coordinate multiple app-servers that are using the same
database. Basically, we are thinking about using a table row as the
coordination mechanism. When an app-server needs to perform an action that
must be exclusive, it will try to lock that table row first. It will wait on
that lock if someone else has it.

Has anyone done something like this before? What's the performance and
resource usage like if the exclusive action is pretty short?  Does PGSQL do
FIFO when multiple connections wait on the same lock?

BTW we are using JDBC to connect to the server.

Thanks for your help.




_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail