News for hackers. Stuff that matters.

dba_leveling_up

The size of the rows vary, but very few tables have large blobs, and there should be much fewer than 3M rows changing per second. Does the change capture use triggers or a different method?
Thanks, posted. I am however also interested to hear from non-technical stakeholders who have supported something similar.

Ask HN: Is it possible to replicate 30TB from 20 DBs to PostgreSQL real-time?

If you had 20 databases spread across 20 servers, could you replicate them all into a single PostgreSQL instance? And can this be done on a server costing less than $100,000?The databases total 30 TB on disk. There are ~30,000 tables. The maximum number of rows in a single table is 1.2 billion. The number of rows changed per second is modest (100s or less).Some of the servers run PostgreSQL,...

( Read More... | 5 comments | 5 points | on HN )