Auroraにpostgres18来たー！！！ aws.amazon.com/about-aws/wha…

software design, postgres18 特集なのか 買うか

Postgresのバージョン違いのバグのせいで大手戻り発生して萎え AmazonLinuxだとまだpostgres18標準で入ってないから注意🫠 ローカルの奴dumpして持ってっても一個バージョン違うだけでリストアできないので

Postgres18でUUIDv7が使えるようになったので、ActiveRecordで使ってみようと思ったんですが、マイグレーションにdefault: "uuidv7()" を設定しないといけないのでConfigで g.orm :active_record, primary_key_type: 'uuid, default: "uuidv7()"' みたいにかいて力業解決したんですがいいんですか？？

CRAZY!!! The best database known to humanity got even better!! Postgres18 is a beast!! 1.) Asynchronous I/O - The biggest performance improvement Faster reads for sequential scans, bitmap heap scans, and VACUUM operations Better throughput by batching disk reads instead of waiting on each one individually More predictable performance managed at the database level rather than relying on OS 2.) UUID v7 - Better primary key performance Maintains all the benefits of UUIDs (global uniqueness, decentralized generation, URL obscurity) Significantly improved indexing and sorting performance compared to UUID v4 Uses timestamp prefix for better data locality and less index fragmentation 3.) B-tree Skip Scans - Smarter index usage Multi-column indexes can now answer queries on non-leading columns Works automatically behind the scenes - no configuration needed Eliminates need for redundant single-column indexes in many cases Particularly helpful for analytics workloads with varied query patterns 4.) Virtual Generated Columns - Reduced storage overhead Computed on-the-fly instead of stored on disk (now the default) Eliminates write overhead from computing values during inserts/updates Great for simplifying queries on JSON data and on-the-fly transformations 5.) OAuth 2.0 Support - Modern authentication Native integration with identity providers like Okta and Keycloak Token-based authentication instead of storing passwords Enables MFA and SSO through external providers Plus 3,000 commits with additional under-the-hood optimizations, bug fixes, and security patches from 200 contributors.

if you are not on Postgres18 you are already late

啊啊 伟大的 Postgres18 感谢您终于带着伟大的 UUIDv7 支持降临世间，拯救被 created_at 字段困住的人们啊✋😭🤚

Less boilerplate, more security. #Postgres18 now supports SCRAM pass-through auth for postgres_fdw dblink_fdw, eliminating stored plain-text passwords. Details in Matheus Alcantara’s blog 👇 enterprisedb.com/blog/postgr…

Postgres18、時系列ソートできてグローバルに衝突しないuuid v7をサポートしてる地味に嬉しいUpdate。 postgresql.org/docs/18/relea…

🚨 pg_dump isn't your backup hero! While it’s useful for exporting data, it doesn’t cover everything needed for complete backups, like WAL files. With #Postgres18, the docs are changing to reflect this. Learn more 👉 xata.io/blog/pgdump-is-not-a…