| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | "Skelton, Adam J" <Adam(dot)Skelton(at)fisglobal(dot)com> |
| Cc: | "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: DDL in active production database |
| Date: | 2023-09-25 00:06:19 |
| Message-ID: | CAKFQuwY8t-9qzO3mBFx2=kGKn5EG7joCj7amo_xWuM=N0DK3Mw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Sunday, September 24, 2023, Skelton, Adam J <Adam(dot)Skelton(at)fisglobal(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Joseph Krogh | 2023-09-25 09:58:56 | Sv: DDL in active production database |
| Previous Message | Skelton, Adam J | 2023-09-25 00:01:28 | DDL in active production database |