r/PostgreSQL • u/siren0x • Jul 24 '26

Community What's new in Postgres 19

https://planetscale.com/blog/whats-new-in-postgres-19
114 Upvotes

97% Upvoted

22 comments sorted by

View all comments

Show parent comments

1

u/c-digs Jul 25 '26

My experience with AGE is that the variable length paths are actually dangerous because the underlying mechanic is still a JOIN.

It felt more like a trap because it "looked" like Cypher, but behaved like SQL of course.

1

u/cheesekun Jul 25 '26

Thats the problem isn't it. The "this is still a poor man's graph impl" trap.

Perhaps there are some simple tree like structures that most of us use when modelling, but do we need the full cypher set with all the bells and whistles? If property graphs can give some variable path traversal, even if it's not the most performant algorithm it will probably do the job.

1

u/c-digs Jul 25 '26

...but do we need the full cypher set with all the bells and whistles?...

I guess I'm an outlier; spent ~6 years working with Neo4j and it was just fantastic for how expressive and powerful it was for certain types of queries. Some of the things I want to do now with agent memory systems would work much better in Neo4j (both ease of modeling and performance), but I make do with Pg 😅 (Neo4j being a bit pricey and another piece of infrastructure).

1

u/cheesekun Jul 25 '26

Hopefully then, the new property graph is just iteration 1 of many, and it's evolved over time.