Re: Avoid deadlocks on alter table

From: Christian Castelli <voodoo81people(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Avoid deadlocks on alter table
Date: 2016-07-06 07:43:03
Message-ID: CAN7CK_xnbt-_sTBxtDfgq_iacVjQFMDJEKJanGkytxQ3=3NS2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2016-07-05 16:01 GMT+02:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(at)sss(dot)pgh(dot)pa(dot)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 Castelliskype: christrack*

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Bianchi 2016-07-06 09:13:49 Update statement results in Out of memory
Previous Message sangeetha 2016-07-06 07:35:02 estimate Index size