On 6/1/2014 12:59 PM, Sébastien Lorion wrote:
it would have been nice to avoid the additional complexity if it had been possible to merge sharded tables on a binary level (which should be much faster than statement level), given that their records will never overlap (i.e. the same record is never present in many shards).
not even remotely possible, since binary replication is at a block level, NOT a tuple level... Also, the index on this merged table will be considerably different than the index on any one of the sharded 'masters' (and in binary replication, indexes are also block replicated).
-- john r pierce 37N 122W somewhere on the middle of the left coast
