Declarative partitioning in PostgreSQL
Declarative partitioning in PostgreSQL
Posted Apr 11, 2024 22:18 UTC (Thu) by grifferz (subscriber, #62128)Parent article: Declarative partitioning in PostgreSQL
With either the old or the new method, can partitioned tables span multiple hosts, or does that kind of partitioning still have to be done entirely in the client logic?
Posted Apr 12, 2024 13:06 UTC (Fri)
by daroc (editor, #160859)
[Link]
Declarative partitioning in PostgreSQL
I don't believe partitions can span separate hosts; although I don't recall the question coming up at the time, so perhaps I am mistaken. I think the fundamental problem would be having some way to introduce consistent constraints across separate instances of PostgreSQL, which sounds hard.