Our Multi-tenancy Journey with Postgres Schemas and Apartment
Brad Robertson
33712

You don’t say above what version(s) of PostgreSQL you used. Performance of databases with large ( > 10,000 ) numbers of tables has been an area of cumulative improvements in recent releases, partly due to the Billion Tables Project. It’s likely that users trying schema sharding using 9.6 would find that the performance issues you encountered on the DB side are substantially reduced or even gone.

Mind you, that doesn’t help you at all with ActiveRecord performance.

Like what you read? Give Josh Berkus a round of applause.

From a quick cheer to a standing ovation, clap to show how much you enjoyed this story.