News for hackers. Stuff that matters.
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
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.
Re:Our Multi-Tenancy Journey with Postgres Schemas and Apart... by zwily on Wednesday December 07, 2016 @07:05AM (#13121959)
We use bucardo to move a schema to a different host with no downtime.