Home-brewed table syncronization

Поиск
Список
Период
Сортировка
От Michael A Nachbaur
Тема Home-brewed table syncronization
Дата
Msg-id 200307091414.19959.mike@nachbaur.com
обсуждение исходный текст
Ответы Re: Home-brewed table syncronization  (Cliff Wells <LogiplexSoftware@earthlink.net>)
Список pgsql-sql
Hello everyone,

While I still have plans to do some more work on RServ, it is apparent to me 
that I need a more immediate solution.  I'm not replicating my entire 
dataset, but rather just some "summary" tables that are maintained by stored 
procedures. This means RServ is an iffy proposition at best for me right now.

So, I'm looking at syncronizing 4 tables from one master database to several 
child databases. I'm thinking of doing the following with DBD::Multiplex:

DELETE FROM TableA;
INSERT INTO TableA (..) VALUES (...);
....

on all the child databases, but I'm not sure what kind of impact this would 
have on my servers.  My impression is that this would hammer the indexes, and 
might blow any memory optimization out the window.  Only a few records in my 
dataset will change from time-to-time, but just the process of determining 
what is different may take more effort than simply rebuilding.

What are your thoughts?  These tables will probably only have a maximum of 
10,000 rows in total, but I'm going to have to syncronize once per minute; as 
a result, I wouldn't like this to take any longer than about 10 seconds.

-- 
/* Michael A. Nachbaur <mike@nachbaur.com>* http://nachbaur.com/pgpkey.asc*/

"Out," he said. People who can supply that amount of firepower don't need to 
supply verbs as well.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Break referential integrity.
Следующее
От: Cliff Wells
Дата:
Сообщение: Re: Home-brewed table syncronization