3 ms·
+1 We are continuously rebalancing customers between database servers. An added benefit is that doing a pg_dump/pg_restore removes all accumulated database bloa
by jacobkg 10y ago
+1 We are continuously rebalancing customers between database servers. An added benefit is that doing a pg_dump/pg_restore removes all accumulated database bloat which decreases size on disk and improves performance
- abishekk92 10y agoHow long does it usually take to do such restructuring? Also, are you able to do this with minimal downtime? I have similar usecase, however, the export and re-import usually takes quite a long time.
- zwily 10y agoWe use bucardo to move a schema to a different host with no downtime.