MIME-Version: 1.0
In-Reply-To: 
 <VE1PR08MB559746D4BEA543C96A8DB57F81FCA@VE1PR08MB5597.eurprd08.prod.outlook.com>
References: 
 <VE1PR08MB559746D4BEA543C96A8DB57F81FCA@VE1PR08MB5597.eurprd08.prod.outlook.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 24 Sep 2023 17:06:19 -0700
Message-ID: 
 <CAKFQuwY8t-9qzO3mBFx2=kGKn5EG7joCj7amo_xWuM=N0DK3Mw@mail.gmail.com>
Subject: Re: DDL in active production database
To: "Skelton, Adam J" <Adam.Skelton@fisglobal.com>
Cc: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005539b9060623ba39"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwY8t-9qzO3mBFx2%3DkGKn5EG7joCj7amo_xWuM%3DN0DK3Mw%40mail.gmail.com>
Precedence: bulk

--0000000000005539b9060623ba39
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=99t 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.

--0000000000005539b9060623ba39
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sunday, September 24, 2023, Skelton, Adam J &lt;<a href=3D"mailto:Adam.S=
kelton@fisglobal.com">Adam.Skelton@fisglobal.com</a>&gt; wrote:<blockquote =
class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid=
;padding-left:1ex"><div lang=3D"EN-NZ" link=3D"#0563C1" vlink=3D"#954F72" s=
tyle=3D"word-wrap:break-word">
<p class=3D"MsoNormal"><u></u>=C2=A0Does Postgres have problems with creati=
on / changes to database schema objects when the database is actively being=
 used?</p></div></blockquote><div><br></div><div>It doesn=E2=80=99t have pr=
oblems.=C2=A0 It does require locks that can preclude active use of those t=
able for selects and updates while the DDL is processing.=C2=A0 Whether tha=
t is an issue for your application depends on the application.=C2=A0 And th=
e duration required depending upon table size and the specific command.</di=
v><div><br></div><div>David J.</div><div>=C2=A0</div>

--0000000000005539b9060623ba39--