Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kxjvg-0001BK-Sm for pgsql-hackers@arkaria.postgresql.org; Fri, 08 Jan 2021 05:03:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kxjvd-0003JP-Qj for pgsql-hackers@arkaria.postgresql.org; Fri, 08 Jan 2021 05:03:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kxjvd-0003JI-H2 for pgsql-hackers@lists.postgresql.org; Fri, 08 Jan 2021 05:03:13 +0000 Received: from smtp-fw-6002.amazon.com ([52.95.49.90]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kxjvZ-0006C2-Gz for pgsql-hackers@postgresql.org; Fri, 08 Jan 2021 05:03:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1610082190; x=1641618190; h=to:cc:references:from:message-id:date:mime-version: in-reply-to:content-transfer-encoding:subject; bh=OzDd9yat0dMHKFHaAJRMVlzJ/GAUSXZn6+C4hNUMGSk=; b=VDC1FkJhsSkiLb1b2jXoU5Vaf3weGf/AqppOIaqSLHpENTVtyG5DTYOk 2GCafWhmGE04SpqOHXxUtKt2+LRcuBB9rHryDFIAhsBjHxYl6dUbVl9nl fvCgE2kVKI6ga5n/DU1SNnhRC8kLSIWW2DZ2Vhw+AWeJ3IAThym6GmZzb A=; X-IronPort-AV: E=Sophos;i="5.79,330,1602547200"; d="scan'208";a="76144761" Subject: Re: Add Information during standby recovery conflicts Received: from iad12-co-svc-p1-lb1-vlan2.amazon.com (HELO email-inbound-relay-1a-715bee71.us-east-1.amazon.com) ([10.43.8.2]) by smtp-border-fw-out-6002.iad6.amazon.com with ESMTP; 08 Jan 2021 05:03:01 +0000 Received: from EX13D03EUC003.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan2.iad.amazon.com [10.40.163.34]) by email-inbound-relay-1a-715bee71.us-east-1.amazon.com (Postfix) with ESMTPS id F18EBA2463; Fri, 8 Jan 2021 05:02:58 +0000 (UTC) Received: from 38f9d36c4abb.ant.amazon.com (10.43.162.125) by EX13D03EUC003.ant.amazon.com (10.43.164.192) with Microsoft SMTP Server (TLS) id 15.0.1497.2; Fri, 8 Jan 2021 05:02:55 +0000 To: Fujii Masao , Masahiko Sawada , Alvaro Herrera , Kyotaro Horiguchi , Masahiko Sawada CC: PostgreSQL-development References: <20201130182528.GA1854@alvherre.pgsql> <594f4419-62aa-c272-ef7d-4287e5c6b654@amazon.com> <627f702d-a04c-b72b-b94f-214f448e2935@oss.nttdata.com> <73037867-b688-c5cc-5f6d-ad73db6ab94d@amazon.com> <02b17df8-cf11-7e5a-31e3-d94c87b28775@oss.nttdata.com> <5517bbfd-27ad-3e97-51e2-cb9ffb8f8a8d@amazon.com> <2ae8a3a6-9647-b08f-90c3-bd57a14755f9@oss.nttdata.com> From: "Drouvot, Bertrand" Message-ID: <6e5b7836-06a2-0a0a-0ef9-a6572789cc6b@amazon.com> Date: Fri, 8 Jan 2021 06:02:51 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:78.0) Gecko/20100101 Thunderbird/78.6.0 MIME-Version: 1.0 In-Reply-To: <2ae8a3a6-9647-b08f-90c3-bd57a14755f9@oss.nttdata.com> Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US X-Originating-IP: [10.43.162.125] X-ClientProxiedBy: EX13D23UWA002.ant.amazon.com (10.43.160.40) To EX13D03EUC003.ant.amazon.com (10.43.164.192) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, On 1/7/21 4:51 PM, Fujii Masao wrote: > Thanks for the review! I pushed the latest patch. > Thanks all of you for your precious help on this patch! The original idea behind this thread has been split into 3 pieces. Pieces 1 (9d0bd95fa90a7243047a74e29f265296a9fc556d) and 2 (0650ff23038bc3eb8d8fd851744db837d921e285) have now been committed, the last one is to add more information regarding the canceled statements (if any), like: * What was the blocker(s) doing? * When did the blocker(s) started their queries (if any)? * What was the blocker(s) waiting for? on which wait event? Does this proposal sound good to you? If so I'll start a new thread with a patch proposal. Bertrand