From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Merge a sharded master into a single read-only slave |
Date: | 2014-06-01 20:10:40 |
Message-ID: | 538B88C0.1040001@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2014-06-01 22:33:37 | Re: Extended Prefetching using Asynchronous IO - proposal and patch |
Previous Message | Sébastien Lorion | 2014-06-01 19:59:31 | Re: Merge a sharded master into a single read-only slave |