Jan Wieck JanWieck
Fri Jun 23 22:34:04 PDT 2006
On 6/23/2006 10:39 AM, Christopher Browne wrote:

> We commonly have databases 40GB in size, or more.  In a Slony-I context,
> the size at which things are liable to get "challenging" is as size
> grows to hundreds of gigabytes.

Actually, the sheer size of the database is only of concern during the 
time it takes to create the replica. Once that is done, the amount of 
data changes is what really counts. Slony-I is a replication system that 
replays every single change to a row. That means that a 4GB database 
with a daily 200% turnover is worse than a 400GB database that changes 
only 1% of its content per day.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #



More information about the Slony1-general mailing list