Re: Update does not move row across foreign partitions in v11
| От | Derek Hans |
|---|---|
| Тема | Re: Update does not move row across foreign partitions in v11 |
| Дата | |
| Msg-id | CAGrP7a39ydOSEaHyXDG=e0tuSw_P9FjBvsOCG0jCGqfh0oDbig@mail.gmail.com обсуждение исходный текст |
| Ответ на | Update does not move row across foreign partitions in v11 (Derek Hans <derek.hans@gmail.com>) |
| Список | pgsql-general |
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@gmail.com> 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
В списке pgsql-general по дате отправления: