New in Postgres 11: Monitoring JIT Performance, Auto Prewarm, Stored Procedures | Hacker News Reader

New in Postgres 11: Monitoring JIT Performance, Auto Prewarm, Stored Procedures

pganalyze.com

73 pointstosh10 comments

(author here)

I had a very positive Postgres experience writing this, as I was able to find three separate bugs before the 11 release.

Two of them have bugfixes merged already (JIT EXPLAIN bugs, auto_explain support for JIT) and a third has a patch pending (track_functions for procedures)

I encourage everyone to test things early & report issues - thats the way Postgres works well for everyone :)

a bit OT... I use Oracle (yep!) everyday. It's a very solid database. However, somehow, I read about postgresql every day, on planet.postgres and in some other web sources (and I use it a bit in side projects). All the qualities of Postgres aside, what sets it apart is that its develeopement unfold under my eyes and there'd hardly one week without an interesting news or comment or blog post, etc (from non marketing people). That's the opposite of Oracle for which I hear news when the databse team in my job upgrades it, ie once every three years (or when I read some advertisement). That makes Oracle dull. That heighten the trust I have into it.

One may argue that's just the way the web is, but nonetheless, it gives me that warm feeling...

I'm clearly biased (PG dev). But am I understanding correctly that you'd basically always prefer projects where development happens in the closed environment? Because aside of that I don't see what PG could do about what you say here.

Edit: I probably misunderstood the parent.

? The author said PostgreSQL's development gives them a warm feeling. If anything, they are saying everything should be like PostgreSQL, which means more open!

I think he's saying he prefers PG, because it is open.

sorry if not 100% clear : I much prefer PG communication and its ecosystem. They both bring a lot of information that builds more trust and is simply enjoyable to hear about.

Oh, I think I must have mis-parsed "That makes Oracle dull. That heighten the trust I have into it." then. I thought you meant you trust Oracle more because it's dull?

I run Oracle and Postgresql databases and would much rather work with pg only. Oracle seems to make things unnecessarily complicated. Even the documentation is easier with pg.

More technical features discussed in HPE's essay: https://h50146.www5.hpe.com/products/software/oe/linux/mains...

I'm curious if, when PostgreSQL 11 makes it to Amazon Aurora, autoprewarm will be available. Currently, when replicas spin up they are cold but having them automatically warm themselves would be fantastic.

Reply on news.ycombinator.com