On Tuesday 02 March 2004 19:34, Thomas Holmgren wrote: > Hi all, > > I have a large number of clients synchronizing with a central database. > The clients update their local data by polling the database for changes > at fixed intervals. I need an efficient way of determining if data in a > table has been changed (either updated, deleted or inserted). Can this > be achieved without scanning the tables using expensive SQL? (my tables > are _big_!) Is there some way to get a "time for last update" for a > specific table? Or something similar I can use?
If you are syncing your entire database, why don't you look at replication solutions which would transfer WAL files and perform any required updates.. Check http://gborg.postgresql.org/project/pgreplication/projdisplay.php HTH Shridhar ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
