best method for mirroring ?

hi folks,

i'm currently mirroring multiple databases w/ postgresql.
this requires some additional support in the application:

each table has an inode_id (as global object id) and an mtime field.
on each insert, an new inode_id is fetched from an sequence and on
each insert/update the mtime is updated.

after some time (i.e. one minute) all new rows are posted to all
other nodes. (the nodes are listed in an separate table w/ their
last-poll time, so evrything newer than the lastpoll is posted out).

this works quite good for my current applications, but I still have
some latency. (depends on the polling time - i dont want to query all
tables evry second ...)

is there an better way to solve this ?

cu
--
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux ITS
 Webhosting ab 5 EUR/Monat.          UUCP, rawIP und vieles mehr.

 phone:     +49 36207 519931         www:       http://www.metux.de/
 fax:       +49 36207 519932         email:     contact@metux.de
 cellphone: +49 174 7066481         smsgate:   sms.weigelt@metux.de
---------------------------------------------------------------------
 Diese Mail wurde mit UUCP versandt.      http://www.metux.de/uucp/