Re: dealing with lock

Thank you Thomas Regards Thomas Le sam. 7 avr. 2018 à 08:01, Thomas Kellerer a écrit : > Adrian Klaver schrieb am 07.04.2018 um 00:02: > >> Is there a way to identify the list of statements that have to rewrite > the table. > > > > https://www.postgresql.org/docs/10/static/sql-altertable.html >

Re: dealing with lock

Thank you Laurenz! Regards Thomas Le sam. 7 avr. 2018 à 00:02, Adrian Klaver a écrit : > On 04/06/2018 12:09 PM, Thomas Poty wrote: > > Thank you Laurenz ! > > > > > > We will certainly have to change our release management. > > > > Is there a way to identify the list of statements that have to

Re: dealing with lock

Adrian Klaver schrieb am 07.04.2018 um 00:02: Is there a way to identify the list of statements that have to rewrite the table. https://www.postgresql.org/docs/10/static/sql-altertable.html Notes "Adding a column with a DEFAULT clause or changing the type of an existing column will require t

Re: dealing with lock

On 04/06/2018 12:09 PM, Thomas Poty wrote: Thank you Laurenz ! We will certainly have to change our release management. Is there a way to identify the list of statements that have to rewrite the table. https://www.postgresql.org/docs/10/static/sql-altertable.html Notes "Adding a column wi

Re: dealing with lock

Thank you Laurenz ! We will certainly have to change our release management. Is there a way to identify the list of statements that have to rewrite the table. If I am right, at least these statements need to do this : - create a unique index - add a column with a default value Regards, Thoma

Re: dealing with lock

On Fri, 2018-04-06 at 16:58 +0200, Thomas Poty wrote: > Here is a bit of context : we are migrating from MySQL to PostgreSQL and we > have about 1000 tables. > Some tables are quite small but some others are very large. The service > provided to our clients > relies on a high avaiability with a m

dealing with lock

Hello All, Here is a bit of context : we are migrating from MySQL to PostgreSQL and we have about 1000 tables. Some tables are quite small but some others are very large. The service provided to our clients relies on a high avaiability with a minimum down time due to any legal deadlines. So, lets