Hacker News Reader

depesz has a nice series of posts about new features: https://www.depesz.com/tag/pg12/

"Generated columns" and "foreign keys to partitioned tables" are two that caught my eye.

Fkeys on partitioned columns is huge.

Does that open the possibility of doing fkeys for partitioned columns in Citus? or is that a completely different technical challenge on the distributed databases?

IMO Citus is the RHEL of Postgres -- so one would have to wait until Citus bases on PG12 I guess. Running a HA DB is so hard so Citus making it a bit easier is super nice

Reply on news.ycombinator.com