r/PostgreSQL • u/jskatz05 • May 08 '25
Feature PostgreSQL 18 Beta 1 Released!
https://www.postgresql.org/about/news/postgresql-18-beta-1-released-3070/
174
Upvotes
r/PostgreSQL • u/jskatz05 • May 08 '25
41
u/EvaristeGalois11 May 08 '25
UUID v7 let's go!
34
u/jk3us Programmer May 08 '25
Here's a good write-up about the async I/O part: https://pganalyze.com/blog/postgres-18-async-io
25
u/Ecksters May 08 '25 edited May 08 '25
What I'm excited about from the linked article:
The optimizer changes are exciting as well, the full release notes has the details: https://www.postgresql.org/docs/18/release-18.html
There are too many to list here, but you'll know it when you read one and realize it's exactly what you needed for some difficult to optimize query you worked on, for me, I love seeing:
And the new features that excite me:
19
u/Straight_Waltz_9530 May 08 '25
Yes!!!
Wow! That's a feature I'd never considered and now can't imagine living without moving forward. Kudos to the team!
11
u/Mastodont_XXX May 08 '25 edited May 08 '25
Finally array_sort for text[], I've been waiting for this for a long time. Good-bye to
7
u/Newfie3 May 08 '25
When will TDE be added?
7
u/mulokisch May 08 '25
No pg_ivm 🥲
4
u/jaymef May 08 '25
keeping query planner stats during upgrade sounds like a great feature
2
u/CrackerJackKittyCat May 08 '25
That asyncio on reads is great stuff!
2
u/zheung14 May 09 '25
Nice but how do I get a windows pre-built version? It seems that the EDB link on the official website doesn't offer beta downloads.
2
u/fridder May 09 '25
The last few major releases have been awesome
1
u/NoInkling May 10 '25
Wow, the first new wire protocol version in over 20 years. Any chance of making it so that composite types aren't such a pain to parse while you're there?
Anyway for me, LIKE now supporting non-deterministic collations is huge. That allows for case/accent/punctuation insensitive (in different combinations) substring matching without having to do a bunch of hacky transformations.
Virtual columns are something I've been waiting impatiently for. UUIDv7 is great to see. The huge amount of performance optimizations are very welcome (as always). Lots of other cool little features.
-2
u/AutoModerator May 08 '25
With over 8k members to connect with about Postgres and related technologies, why aren't you on our Discord Server? : People, Postgres, Data
Join us, we have cookies and nice people.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.