Re:Our Multi-Tenancy Journey with Postgres Schemas and Apart...
by jacobkg on Tuesday December 06, 2016 @09:57AM
(#13114987)
+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
[ Parent
| on HN ]
Re:Our Multi-Tenancy Journey with Postgres Schemas and Apart...
by abishekk92 on Wednesday December 07, 2016 @03:11AM
(#13121201)
How 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.