[Bucardo-general] 10 millions inserts&updates/day?

[André Luciano Dias]

Hi,

I´m looking for a multi-master solution for Postgres 8.3 and i´m
trying to figure out if Bucardo will do the job.

I have a database with 10.000.000 Inserts/Day (9.000.000 in just one
table) and the same number of updates, one for each row. (again,
9.000.000 in just one table). No deletes. The rows are small, the
database grows about 3 GB/day. The updates will set just one timestamp
field.

All data will be send to the servers equally distributed over the day
(well...in theory). In other words, there will be 115 inserts/second
and 115 updates/second every day

The big table (the one with 9.000.000 rows/day) will be partitioned by
month, which means that the max number of rows for one table will be
9.000.000 x 31 = 279.000.000 rows (we can change this to a smaller
interval. 15 days maybe).

There will be 2 masters databases in different datacenters, the
replication will be over WAN. The ammount of data (10.000.000 rows / 3
GB) is the sum of the 2 servers (for example, 6.000.000
inserts/updates in server A and 4.000.000 in server B). We need to
replicate as fast as possible! :)

So...anyone knows if Bucardo is for me?? I´m having troubles to find
information about performance.

Thanks

André Dias