Hi all,
This behavior makes the new data sharding functionality in v11 only marginally useful as you can't shard across database instances.
Considering data sharding appeared to be one of the key improvements in v11, I'm confused - am I misunderstanding the expected functionality?
Thanks!
On Fri, Feb 22, 2019 at 9:44 AM Derek Hans <derek.hans@xxxxxxxxx> wrote:
I've set up 2 instances of PostgreSQL 11. On instance A, I created a table with 2 local partitions and 2 partitions on instance B using foreign data wrappers, following https://pgdash.io/blog/postgres-11-sharding.html. Inserting rows into this table works as expected, with rows ending up in the appropriate partition. However, updating those rows only moves them across partitions in some of the situations:
- From local partition to local partition
- From local partition to foreign partition
Rows are not moved
- From foreign partition to local partition
- From foreign partition to foreign partition
Is this the expected behavior? Am I missing something or configured something incorrectly?Thanks,Derek
Derek
