Database Is Postgresql. Whether a workable scheme of sharding?

The B2B project. Accordingly, all perfectly Karditsa for client_id. Sharding configured in the application immediately in any case - may not be necessary, but better to let it be. Database is postgresql. The shard is a separate database with 200-250 firms (for 5-100 users in each), then if that can be added. To go into the base going through pgbouncer. After the start will be to contact a professional firm to outsource to support the infrastructure. It is a viable scheme or the professional dba from such a head will seize, when you start to supportit such a decision?
April 4th 20 at 00:43
1 answer
April 4th 20 at 00:45
Well, that's what prevents to apply "to a professional firm outsourced" to the start if they still have to support it, they will tell you about the best option.

Sharding configured in the application immediately, just in case

this is alarming, this should be done not just in case, and when the real benefit
There is a question of taste and, probably, the skill, the number of teams. I find it easier to move walls and to estimate the position of the Foundation before the house populated people. I think that juggling the data structure, store them in a running project, without stopping, one of the most complex and resource-intensive operations on the web. There zhezh only migration to cook and you need to check a lot of time. And more options of kickbacks to calculate, just do the code to write and read in two modes, the data does not yet migritude. It is immeasurably more complicated design in the initial stages of the database so that it can be easily drank. But again, a matter of taste. - Kenyon_Cruickshan commented on April 4th 20 at 00:48
@Kenyon_Cruickshan, well here it is done based on the analysis of real queries in the system? Maybe in reality it would be better to chardet for, say task_id and not client_id. "Just in case", sounds like the implemented hypothesis without verification. - Sandrine.Weimann21 commented on April 4th 20 at 00:51
@Kenyon_Cruickshan,
I find it easier to move walls and to estimate the position of the Foundation before the house populated people. I think that juggling the data structure, store them in a running project, without stopping, one of the most complex and resource-intensive operations on the web.

Usually it is in order to simplify the working of project, planning its architecture on the stage of the Foundation and requires an experienced professional with diverse experience, who have seen different rake and will be able to offer an option in which subsequently all will be much easier. - Charlie_Beer commented on April 4th 20 at 00:54
Tell me that coat with pearl buttons warm enough? Why do you need a coat, now is not the season? )))

In fact, the question someone something can tell? How effective-ineffective to Arditi in Postgresql databases (non-virtual shards, not schemes, not partitions, namely databases). To be able to safely carry them on the real server, and pgbouncer to describe the configuration of this case. - Kenyon_Cruickshan commented on April 4th 20 at 00:57
@Kenyon_Cruickshan, Effectively, when the horizontal sharding is not satisfied, but about pgbouncer is nothing to say, usually through a foreign data wrapper is (though that was long ago, maybe pg11-12 what's new there) - Sandrine.Weimann21 commented on April 4th 20 at 01:00

Find more questions by tags PostgreSQLPartitioning and database shuffling