Re: pgsql: Fast ALTER TABLE ADD COLUMN with a non-NULL default

From: Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>, pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Fast ALTER TABLE ADD COLUMN with a non-NULL default
Date: 2018-03-28 12:13:03
Message-ID: 5ABB86CF.80907@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

(2018/03/28 13:25), Tom Lane wrote:
> Andres Freund<andres(at)anarazel(dot)de> writes:
>> There's also a few of that annoying postgres_fdw thing. Some of my
>> critters hit that regularly :(. We need to figure out what's going on
>> there.

I plan to work on this after the commitfest.

> Yeah, really. I've made several sustained attempts to reproduce that
> locally, on every machine I have, without success.
>
> It's weird, because longfin has shown that failure a couple of times,
> but I've not been able to reproduce it in manual runs on longfin's host,
> which makes little sense. I'm reduced to a theory that the buildfarm
> script creates an environment different from manual runs --- but I cannot
> see what that would be.

Thank you for taking the time to work on this!

Best regards,
Etsuro Fujita

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2018-03-28 12:39:30 pgsql: Transforms for jsonb to PL/Python
Previous Message Pavan Deolasee 2018-03-28 09:14:44 Re: pgsql: Optimize btree insertions for common case of increasing values