Live data from Hacker News

PostgreSQL 15

postgresql.org

131–132 of 132 posts

Re: PostgreSQL 15

#131
post #2

Glad to see all the new regex functions. I recently moved a database from AWS Redshift to Postgres on Heroku and was shocked to see how many functions like regexp_substr() weren't available. Wish this had come sooner so I didn't have to rewrite so many of my queries.

That’s an interesting change from a analytical to transactional postgres flavour. What workload is on this DB?

The app is so small that we didn't need a separate database copy just for reporting.

Re: PostgreSQL 15

#132

Earlier quoted context omitted.

Postgres has released a new major version each year for a long time. The only change is that versions used to be X.Y.Z, and now it just used X.Y. Now, X gets incremented for every major version, so it seems like it's moving faster.

The difference is that in place upgrades aren't possible for major versions.

pg_upgrade is the way to do in-place upgrade between major versions:

https://www.postgresql.org/docs/current/pgupgrade.html

Post reply on HN