From: Cliff Wells <LogiplexSoftware@earthlink.net>
To: pgsql-sql@postgresql.org
Subject: Re: Home-brewed table syncronization
Date: 09 Jul 2003 14:28:57 -0700
Message-ID: <1057786137.15508.29.camel@software1.logiplex.internal> (raw)
In-Reply-To: <200307091414.19959.mike@nachbaur.com>
References: <200307091414.19959.mike@nachbaur.com>
On Wed, 2003-07-09 at 14:14, Michael A Nachbaur wrote:
> 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.
Keep a timestamp associated with each record. Only update the records
with timestamps later than your last sync.
--
Cliff Wells, Software Engineer
Logiplex Corporation (www.logiplex.net)
(503) 978-6726 (800) 735-0555
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: LogiplexSoftware@earthlink.net
Subject: Re: Home-brewed table syncronization
In-Reply-To: <1057786137.15508.29.camel@software1.logiplex.internal>
* 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