PostgreSQL 18 brings big upgrades to constraints! 🔒

Gülçin Yıldırım Jelínek Xata.io breaks down what’s new—from temporal PK/FKs to NOT ENFORCED constraints and better partition support—and how to use them in real systems. lnkd.in/d_xZ6HD2

#PostgreSQL #P2D2 #PG18 #DataIntegrity

The journey to virtual generated columns For some reason, when I started out on this project, I decided to start with virtual generated columns. I think on balance that might have appeared to be the most requested kind, and maybe I also thought it was the easiest to implement first. I was wrong!

One of the headlining features of PostgreSQL 18 is virtual generated columns, which our Chief Architect Peter Eisentraut worked on. He tells the engaging story of that feature on the EDB blog: www.enterprisedb.com/blog/journey... #PostgreSQL #PG18

PostgreSQL 18: Better I/O performance with AIO This blog post explores various I/O option with PostgreSQL version 18. You can dive in to check the performance in detail.

#PostgreSQL 18 new #async io already seems to yield signficant #performance gains even in its first iteration:

www.cybertec-postgresql.com/en/postgresql-18-better-...

#pg18

#PG18

panel 1: close up of the seadweller's eyes as they widen, and the shadow completely engulfs him. he gasps quietly at what he sees panel 2: the large shadow reveals itself to belong to a large shark, which opens its mouth wide as the squid creature tries to swim past panel 3: the seadweller yells "no wait!!" as he still clutches his shoulder panel 4: it's too late. the shark bites down and the squid creature is rendered a mess of severed tentacles and a head.

#pg18 cw: animal death

Dankt Bertil Huzen voor het verkondigen van mijn mening #vk #pg18 http://yfrog.com/h459745331j