On Sunday, September 24, 2023, Skelton, Adam J <
Adam.Skelton@fisglobal.com> wrote:
Does Postgres have problems with creation / changes to database schema objects when the database is actively being used?
It doesn’t have problems. It does require locks that can preclude active use of those table for selects and updates while the DDL is processing. Whether that is an issue for your application depends on the application. And the duration required depending upon table size and the specific command.
David J.
