4 ms·
We use a similar scheme. The biggest driver for us is being able to move tenants around between databases to balance load as our tenants grow.
by zwily 10y ago
We use a similar scheme. The biggest driver for us is being able to move tenants around between databases to balance load as our tenants grow.
- 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.