Home > mailing lists

Re: Avoid deadlocks on alter table - Mailing list pgsql-general

From	Christian Castelli
Subject	Re: Avoid deadlocks on alter table
Date	July 6, 2016 10:43:27
Msg-id	CAN7CK_xnbt-_sTBxtDfgq_iacVjQFMDJEKJanGkytxQ3=3NS2g@mail.gmail.com Whole thread Raw
In response to	Re: Avoid deadlocks on alter table (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses	Re: Avoid deadlocks on alter table (Christian Castelli <voodoo81people@gmail.com>)
List	pgsql-general

2016-07-05 16:01 GMT+02:00 Adrian Klaver <adrian.klaver@aklaver.com>:

Does the server log have the details, per above?

No, it copies just the schema from base_template with a CREATE TABLE x AS base_template.x WITH NO DATA.

2016-07-05 17:24 GMT+02:00 Tom Lane <tgl@sss.pgh.pa.us>:

I think it'd likely be enough to add the FKs one at a time, rather
than all in one transaction.

Ok I'll try first to do this.

Thanks.

Christian Castelli
skype: christrack

From: sangeetha
Date: 06 July 2016, 10:35:07
Subject: estimate Index size

From: Ivan Bianchi
Date: 06 July 2016, 12:13:56
Subject: Update statement results in Out of memory