[udfalkso]

This might be best done using triggers. I've had good experiences with the Hair Trigger gem for managing these in rails.

[gigatexal]

Trigger would work. But going the pg_notify approach could allow for asynchronous updating whereas the trigger approach could slow writes.