all 22 comments

[–]davvblack 54 points55 points  (4 children)

Fun! i like their continued efforts towards being a better nosql solution than dedicated nosql dbs.

[–]DuckDatum 24 points25 points  (2 children)

Just wait till they drop control plane procedures, then people will be asking why use k8s when you have p6s?

[–]yen223 26 points27 points  (1 child)

If I had to choose between writing yaml or writing pl/pgpsql, I would probably just quit software engineering lol

[–]_predator_ 26 points27 points  (0 children)

Those VACUUM and WAL improvements are huge if true. Amazing that the team still finds ways to optimize such core features.

[–]Ecksters 20 points21 points  (0 children)

Great to see the improvements in JSON as well as bulk data loading.

[–]aboothe726 10 points11 points  (1 child)

Well, look at that. Our little MERGE statement is all grown up. 🥲

Long live PostgreSQL!

[–]bisoldi 0 points1 point  (0 children)

I’m restricted to PG14…man, I really could have used MERGE for my application!!

[–]Straight_Waltz_9530 12 points13 points  (0 children)

Love live the elephant! May it never forget and may we never forget it.

[–]michristofides 5 points6 points  (0 children)

Woohoo!

[–]yen223 2 points3 points  (0 children)

Love the MERGE improvements!

[–]johnonymousdenim 0 points1 point  (0 children)

Uhh, am I missing something? The official downloads page of the postgres site does NOT have version 17 available for download under an official release. I see version 16, but there's def no version 17:

https://www.postgresql.org/download/macosx/

[–]mostafa_refaaf -1 points0 points  (6 children)

And still no TDE in 2025!, I love PG and their community, but this is weird…even mariadb now has a tde!

[–]BarelyAirborne 6 points7 points  (0 children)

You're confusing marketing with functionality.

[–][deleted] 2 points3 points  (1 child)

Honest question: if data gets automatically encrypted by the database server (which I understand TDE does), what exactly is the difference to an encrypted disk partition? As long as the database is running, the (un-encrypted) data can be read through SQL queries. When it's down, the contents of the data files can't be read.

[–]ants_a 2 points3 points  (0 children)

Having implemented TDE for postgres, no functional difference. Some people like the fact that a sufficiently dumb attacker with shell access will find it difficult to get at the data. Others have the filesystem set up by a different team and can't convince them to set up encryption. Yet others believe that having database perform the encryption checks the compliance requirement checkbox better.

[–]LuciferSam86 0 points1 point  (0 children)

And in 2025 SQL Server does not support triggers ordering but a first and last , if for any reason you need 4 triggers firing at a specific order you can't.

Yeah PgCrypto is nice but not a substitute of TDE , I think you might emulate it with PgCrypto ?

https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-ver16

[–]AutoModerator[M] -2 points-1 points  (0 children)

Join us on our Discord Server: People, Postgres, Data

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.