Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

PostgreSQL 18 Released

postgresql.org

Post reply on HN
Print view View original

1–10 of 23 posts

Re: PostgreSQL 18 Released

#2

Post by mattashii »

Those are some great features. More than I remembered, and it's only been a year.

Personally, I'm very happy to see parallel builds for GIN indexes get released - (re)index time for those indexes is always a pain. I'm looking forward to further improvements on that front, as there are still some relatively low-hanging fruits that could improve build times even more.

Re: PostgreSQL 18 Released

#5

Post by ktosobcy »

Eh... interesting features, yet docker upgrade is still huge PITA because upgrade between major versions is not supported :/

I love PostgreSQL, but this is just utterly annoying and discouraging to use it…

Re: PostgreSQL 18 Released

#6

Post by jeltz »

ktosobcy wrote: post #5

Eh... interesting features, yet docker upgrade is still huge PITA because upgrade between major versions is not supported :/ I love PostgreSQL, but this is just utterly annoying and discouraging to use it…

That is mostly an issue with the official docker image, not a PostgreSQL issue. Upgrading to a new major is easy if you use the Debian packages and is fine with a couple of minutes downtime. There is no reason a docker image could not do the same.

The issue with PostgreSQL which the Debian packages handle fine but the Docker Hub's image does not is that you need both the executables for the old and the new major version of PostgreSQL when upgrading. This just works with Debian packages but not with the Docker image.

Re: PostgreSQL 18 Released

#8

Post by jeltz »

sudarshnachakra wrote: post #3

Does this release have the TAM (Table Access Methods) patch set from orioledb? Or at least parts of it?

I don't think so. What do you need it for if I may ask? If some people actually need a patch it is much more likely to get people working on it to make it committable.

Re: PostgreSQL 18 Released

#9

Post by ksec »

jeltz wrote: post #8
sudarshnachakra wrote: post #3

Does this release have the TAM (Table Access Methods) patch set from orioledb? Or at least parts of it?

I don't think so. What do you need it for if I may ask? If some people actually need a patch it is much more likely to get people working on it to make it committable.

TAM is prerequisite for OrioleDB. And I am guessing OP like me is looking forward to orioledb being used as default or even upstreamed.

Re: PostgreSQL 18 Released

#10

Post by ktosobcy »

jeltz wrote: post #6
ktosobcy wrote: post #5

Eh... interesting features, yet docker upgrade is still huge PITA because upgrade between major versions is not supported :/ I love PostgreSQL, but this is just utterly annoying and discouraging to use it…

That is mostly an issue with the official docker image, not a PostgreSQL issue. Upgrading to a new major is easy if you use the Debian packages and is fine with a couple of minutes downtime. There is no reason a docker image could not do the same. The issue with PostgreSQL which the Debian packages handle fine but the Docker Hub's image does not is that you need both the executables for the old and the new major vers…

I'm fully aware why it's an issue with official image. But even with debian (or any other "packaging") there are hoops to be hopped through due to said missing upgrade handling which IMHO is very annoying.

They do handle minor versions upgrade so the code handling upgrading is there but devs seems to be quite adamant against adding major version upgrade. I (well, a lot of people judging from votes and comments in https://github.com/docker-library/postgres/issues/37 and stars in https://github.com/tianon/docker-postgres-upgrade) would love that, and only between subsequent version would be more than enough…

Post reply on HN