Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i0FNt-0002l7-B0 for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Aug 2019 01:25:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1i0FNr-0000ft-7f for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Aug 2019 01:25:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i0FNq-0000U1-Ox for pgsql-hackers@lists.postgresql.org; Wed, 21 Aug 2019 01:25:54 +0000 Received: from mail-pg1-x544.google.com ([2607:f8b0:4864:20::544]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i0FNi-0002Tw-Hr for pgsql-hackers@postgresql.org; Wed, 21 Aug 2019 01:25:53 +0000 Received: by mail-pg1-x544.google.com with SMTP id n4so332853pgv.2 for ; Tue, 20 Aug 2019 18:25:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=OmrGXtuUahujz07ASW2wgGErgud5yPXwOczHI311AhI=; b=n8LEW2AKQqtN1uNiMfMkmFaJXhwEGyE9vCwMjx4iYrRXSDSvUdQCVPcBWUVNZB4a6R Atp8AGka9GxGA5xeTqjb0Zaxm8tKKbef7NzSdajRf9VRqd1nWo/tFC/jmDC/0J4wlxba /aEu34OlTNb/a4Taw6++s+tZZv30i/eMRzTB4Els+bjCQHEZPRc2RwCc0IZGvENpIdDy fqzfgRePtcWOs7rm7Vm+ZujLp0MusXz9QMSWPEVlvSlA6TO/VxnisTaETx3PFeF+oeLj cSKve21rKXK6ZI8sZfx8/RkqsBES7Xww8c7rrqVV1n23m+eBWODuYVzZrfen3nJf8yHh tfag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=OmrGXtuUahujz07ASW2wgGErgud5yPXwOczHI311AhI=; b=BBRe2zOszb19g6e8LNTrD+RWcQcPPMIo2THJ2njf14CYh+d/1oTczcr97yKqEUHtvF kyk6Nfi30ZcZexgNS1eEgIK5GRxHQP8W0g5CQrwXe4lZNBb78NdxYcdqpYmNJudSSwME okTyQHeTxTWhd5O9s9fWS0Vbn+DwKxDIDnPUebsIDIvp6Fb9jtGISWXDeV2fuhKpkReQ n0CGcGbZE7T4TYlSdaRdqEJhcgfpDmYJ1PVc5s9T1V/PKjfmad5uH1flgfPGyXTknSyK G9VYefF/8syyGDF8wQpdbz29arB+JPUdBdpbSnctYWrzpcIZNg1o70fT2JC6PMdKaAYn Bkpg== X-Gm-Message-State: APjAAAUGWfZu8LL4jII0DuIem4yCsJJFT5maYm0Xc7EePoPU1yROO3EC gtrDYI50hscTgGQ87B3ENr0HgC2UW03FqfT0dH19nN1WulO62kFT9wJM7At1l6grTLZSkQ5y1Rc COZ4LPiy0ZOi9KHyqgoTP0dbyU0ROnqzj+tpauXavD7yKb6uRX2zXuMWuibYHRLaP7mvyTk2ll2 Br12DwgHU6kP8t X-Google-Smtp-Source: APXvYqy1LhAtPyhegRZCxDPS85sgXuQIP5Pv+LiEnmaoUvEP9DenCLAQvilNXjihtbd4ZzinxXrDeA== X-Received: by 2002:a62:4d41:: with SMTP id a62mr14577479pfb.155.1566350744284; Tue, 20 Aug 2019 18:25:44 -0700 (PDT) Received: from osaka.octopusnet (p8584121-ipngn39001marunouchi.tokyo.ocn.ne.jp. [180.39.36.121]) by smtp.gmail.com with ESMTPSA id y14sm18453174pge.7.2019.08.20.18.25.42 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 20 Aug 2019 18:25:43 -0700 (PDT) Subject: Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions To: Tom Lane , Stephen Frost Cc: Robert Haas , Tomas Vondra , Amit Kapila , "pgsql-hackers@postgresql.org" References: <30823.1565030571@sss.pgh.pa.us> <32103.1565032053@sss.pgh.pa.us> <20190806005225.GM29202@tamriel.snowman.net> <6cba0dff-485b-6781-d659-0a376b966c89@2ndquadrant.com> <20190806021616.GP29202@tamriel.snowman.net> <54620b18-60b7-4b9b-7d1d-90a6464ab333@2ndquadrant.com> <5879.1565121423@sss.pgh.pa.us> <20190806214355.GA29202@tamriel.snowman.net> <29770.1565810142@sss.pgh.pa.us> <20190814211520.GK16436@tamriel.snowman.net> <28723.1565882573@sss.pgh.pa.us> From: Ian Barwick Message-ID: Date: Wed, 21 Aug 2019 10:25:40 +0900 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.8.0 MIME-Version: 1.0 In-Reply-To: <28723.1565882573@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 8/16/19 12:22 AM, Tom Lane wrote: > Stephen Frost writes: >> * Tom Lane (tgl@sss.pgh.pa.us) wrote: >>> In hopes of moving this along, I've pushed Ian's last code change, >>> as there seems to be no real argument about that anymore. >>> >>> As for the doc changes, how about the attached revision of what >>> I wrote previously? It gives some passing mention to what ALTER >>> SYSTEM will do, without belaboring it or going into things that >>> are really implementation details. > >> It's certainly better than what we have now. > > Hearing no other comments, I've pushed that and marked this issue closed. Thanks! Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services