News for hackers. Stuff that matters.

A comment on An early look at Postgres 14: Performance and monitoring Improvements. Parent comment

Re:An early look at Postgres 14: Performance and monitoring ... by aseipp on Saturday May 22, 2021 @09:59PM (#27251848)
MySQL has transactions for DDL changes since 8.0.
[ Parent | on HN ]
Re:An early look at Postgres 14: Performance and monitoring ... by tpetry on Sunday May 23, 2021 @02:58AM (#27252958)
MySQL has atomic ddl, which means if a ddl operation fails it is reverted. But PostgreSQL has really transactional ddl which means you can do ddl operations in a transaction and you can commit/rollback multiple ddl operations at once and not each by itβ€˜s own like MySQL does.

https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html

[ Parent | on HN ]