3 ms·
I love Postgres, it’s an incredible piece of software, I have to say though, this is the least exciting update I’ve seen, in the last 10 years that I’ve been us
by garyclarke27 6y ago
I love Postgres, it’s an incredible piece of software, I have to say though, this is the least exciting update I’ve seen, in the last 10 years that I’ve been using it.
Probably because it’s now so capable, the only major missing feature for me is, automatic incremental update to materialized views, one of the few important remaining advantages that Oracle has over Postgres.
- Tostino 6y agoThis release had quite a few patches that just weren't quite ready to go out yet, so were not included. There was some work done which reduces the per-connection overhead and allows many many more direct PG connections before performance degrades, while increasing overall performance with high connection counts by a ton...but it just wasn't quite ready and missed the deadline by a little. The memory based stats collector is another patch in the same vein, where it wasn't quite ready for 13. That said, many of these features are quite impressive and will offer nice wins for many workloads, incremental sorting is very cool, as is the memory bound hash aggregation. I'm with you on automatically updated materialized views, it's been something i've needed and been waiting for a long while now, and I am hoping it gets more focus. The current patch-set being worked on for it seems to have quite a few limitations.
- combatentropy 6y ago> I have to say though, this is the least exciting update I’ve seen I agree. For me, it is a sign of maturity. It's not the only sign. It could be a sign of stagnation! But from what I know, having used it for over a decade, I am happy to be in the midst of "boring software", at least for my database.