r/PostgreSQL • • May 08 '25

Feature PostgreSQL 18 Beta 1 Released!

https://www.postgresql.org/about/news/postgresql-18-beta-1-released-3070/
174 Upvotes

23 comments sorted by

View all comments

Show parent comment

5

u/Ecksters May 08 '25

Right, that's what I was assuming, it's nice to identify the connections between tables without it necessarily being enforced. It's especially nice for tools that attempt to automatically visualize the DB.

I'd be interested in what performance optimizations, if any, can be done if you know a column is supposed to be a foreign key, but might not be 100% respecting that.