From: Michael A Nachbaur <mike@nachbaur.com>
To: pgsql-sql@postgresql.org
Subject: Home-brewed table syncronization
Date: Wed, 9 Jul 2003 14:14:19 -0700
Message-ID: <200307091414.19959.mike@nachbaur.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@nachbaur.com
Subject: Re: Home-brewed table syncronization
In-Reply-To: <200307091414.19959.mike@nachbaur.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox