Thanks Thomas.
Still fancying the manual approach litlle bit more.
Will probably go with 8 database and 32 schema per machine. This way, will keep in limits for administration tools as well as autovacuum, also will be ready for connection pooling, as 8 databases is not to much.
This will give us 256 shard per machine, but will be tunable. The lower number will also prevent to much memory/disk fragmentation and with this bad cache hit ratios.
Will also use monthly partitioning per shard, to reduce the change of big tables forming.
Thanks everyone.
