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 1nhkB7-0002Gr-Ae for pgsql-general@arkaria.postgresql.org; Fri, 22 Apr 2022 03:41:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nhkB6-0001sY-6n for pgsql-general@arkaria.postgresql.org; Fri, 22 Apr 2022 03:41:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nhkB5-0001sP-Ip for pgsql-general@lists.postgresql.org; Fri, 22 Apr 2022 03:41:51 +0000 Received: from mail-tyzapc01on2041.outbound.protection.outlook.com ([40.107.117.41] helo=APC01-TYZ-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nhkB1-000260-Ey for pgsql-general@postgresql.org; Fri, 22 Apr 2022 03:41:50 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Ufb4w8DiDnUNbIcP5o3BiIJjncuTnQ5VZXjsYJvTzZWGXs/M4olapTfPe+3Wji892CJWpSCtQOfzyMuO64dQUeD6NIgG32a28JvnZ7iJ0YfSy70/e6aG3YjJcAjv5OOCxhUDejnvT1pLTBZI+e93qmfXrHlgcs9hxzWO5WYcabrdO1SwQtkEdUp/LLIHQsb2IfV63DX5HuBqOxySi1DCZAXZhOYtEXkl1NYlwo9Zbs/aRgAM7b8giWnlN0YU7fq9ItJHz7D7r4Ug4bxKaJNXujt1ly0Qd2RUY2YzvLgTCsRu0P5yikKEB7BPcetUNOB0/LVznx7WIclgA4Z+W9uyYg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=/Or8TALrW2P3ZH7JMopfrb5kqaPXsZlITEqM+Fhy2pU=; b=CyOqbxHeTvfTrOBamKLhP27czL8PikOnS+3jmxwK6foxT/uDkA+2/nVVFU7FniMpeRbfx9DWTkr4dYnWrXIVyOuEAbQd5mA8aWd0usPmE+XDlDdXGLviLlTV1Am+aO7/uOu9NiB7F2PBOvmHUf29hqJ3mRb0+aXDZI3V7A9qKGg9kmZVRLHsZYo461j8Pxkv94EJMaz+N6IbGPTvxKB8JRB+VpopqgzsabZPQYPPC6aYMI86biqgNNcLfboqakXVEeYWfvM4E7ISf+aKJY7QCLlPmYILnWLsbYC0yp5Y9hZEzOETHOn32g+MkwU/SJ8nRutJAtkxlzmnX2mrHX1lEQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=lavainternational.in; dmarc=pass action=none header.from=lavainternational.in; dkim=pass header.d=lavainternational.in; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=lavainternational.in; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=/Or8TALrW2P3ZH7JMopfrb5kqaPXsZlITEqM+Fhy2pU=; b=olBcais9/lKMmyVMigQWN26mCMJV8qQbBiLUCSjMX4qYMl+Mt6y3FXPYeBzjTerupO+P2y1tKCdt3BsYb+akbdHe1aaPRmHFjRvXFOAAvpsODvkiNNAQ2z7yCMWIMbSTgq2pHBAbJt0JmKISNLx0BjlCPlUYRo6xj5g4rg55ZubAq7g02QApt0ujgqf35QfbU5IVrZ5kXmG47IzyzL88FQ//yGRxwAoXUyeo3jZmrp/17Fa3FLxElHCWHvkojEDIoy2FMQ3FPs4MKChFZpccidbo5espW8J6j9rcFMhHbWeXp9duDogtJhH5M1skZlysnxaq4p495lZkkmSEuJ9PBQ== Received: from KL1PR0601MB4433.apcprd06.prod.outlook.com (2603:1096:820:7b::11) by HK2PR06MB3348.apcprd06.prod.outlook.com (2603:1096:202:3a::21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5186.15; Fri, 22 Apr 2022 03:41:41 +0000 Received: from KL1PR0601MB4433.apcprd06.prod.outlook.com ([fe80::cddd:ee77:c86e:1ca9]) by KL1PR0601MB4433.apcprd06.prod.outlook.com ([fe80::cddd:ee77:c86e:1ca9%5]) with mapi id 15.20.5186.015; Fri, 22 Apr 2022 03:41:41 +0000 From: Ram Pratap Maurya To: Adrian Klaver , "pgsql-general@postgresql.org" Subject: RE: Huge archive log generate in Postgresql-13 Thread-Topic: Huge archive log generate in Postgresql-13 Thread-Index: AdhTFtcEyGI0ruNgRta+FOh1rB9IDgAJpBcAABfi6rAAAo1g4AAaqjCAABcpu+AASsSVgAAYP/+Q Date: Fri, 22 Apr 2022 03:41:41 +0000 Message-ID: References: <5e94410e-ae0e-db88-24cc-58805a9f73d0@aklaver.com> <691f97fa-df1b-be3f-76fe-31a9390ba0b3@aklaver.com> <87593cae-6123-05dc-344a-23e3ffca7a4e@aklaver.com> In-Reply-To: <87593cae-6123-05dc-344a-23e3ffca7a4e@aklaver.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=lavainternational.in; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: fc00be5a-d90e-463a-5fd2-08da24120370 x-ms-traffictypediagnostic: HK2PR06MB3348:EE_ x-microsoft-antispam-prvs: x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: f7gc+JKBvf6gYXc2xzN+9sEt85UR/z/l0nK7u/L17XoTodgbU+hU8Am5BpLAkrx4t1uDp/1t4w75EiRrsruw1DTvvpeubmZAMEH566lXgYHgN3n5lTHK/1yEFEYj7f1S388o6P+GGrYM43UX1A2SN8rXqNlsnXgphgbSkkF/KZ84HUbnLuaSWyi/wDSuPMdkcABP02aRmrcx6F05zVt63C6+GzfEVR59JPYl3mfe9H3uQ5akNCJ0z4OKnTeXtvIDs19P7QTzJ4p0YOhG+MYVtgMAGrW4+kbjZg4rXdMGgmWCCo72FjjU5CixZrIVbXm1V7XIhy0RRrxDJwxdZbYHQErcvLeh9kKD/AwM/KV+ejVd8lCINuh/Ko7+Sq5H6okCWB1PjrXV8wpJYWjB0Vf9anL515EELSGUzDMqQ2Q7oZuMGGhTlCBeVLEajqw2WJa1PRC7WhaNTCiPcgbCxHaIANv+ojBdR8/y30GmEVDgsDfImPROrPIMLl1ji43yEHmNbr0/1zn1ATwTk5+4+ORxNaje91lTdvYgiT9f4eIZshNA9ggJIFOaxVgxrwEzKqyE2mhYmblScuEL+wt0yh6J3KyYWaBfliGMmvks43KkVT2AezjzDkrQOq+MBwGXwj7IaAzcbABheFxJ5FAVoMNj3SAIdWS8XtXNlqTlQyi8u1C3du9MPFCxUV2aB3kWBrcJDmUzBE97uFCOjUjQlYJ3S3XJgndw+51xKcvFzjKANNA= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:KL1PR0601MB4433.apcprd06.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230001)(366004)(316002)(33656002)(55016003)(7696005)(6506007)(53546011)(8676002)(64756008)(9686003)(2906002)(66446008)(71200400001)(76116006)(86362001)(66556008)(66476007)(66946007)(8936002)(52536014)(508600001)(38100700002)(110136005)(4744005)(122000001)(83380400001)(38070700005)(5660300002)(186003)(26005)(14583001);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?NVNoRlM1U0dJcWhDSHNXNkUvSkFvNnBTN0h5MnJBRGhNdmJLZWJ3UWx6b3lR?= =?utf-8?B?eGZ3V2g0aEE1ekhTRis4Z2dqaElDNkY2RTF6a1YydDdWSEpOTlUySjVzYTg3?= =?utf-8?B?aG0xV25qVjU1cGdFZzE4WE9TRWJlVVkzTUhnZUxiajJzaTNybUx2WWxKYnlr?= =?utf-8?B?d1VjR1o2amhSeEFsRG01elF1ejhDWEE5c0NBOXpSK25jRDR3SWEwUks4TXBs?= =?utf-8?B?VmRZQW5WTnZlK0JGbkF1ZU9TalNkVzAwQjhURUxyV2E1Ums3WDdhNGxFUFk3?= =?utf-8?B?QVJ2S1MxV3c0NDBZenlTNnZJVWFHRkdLWjY3YmhzQmhFc3NIS0p2VVFJSzgx?= =?utf-8?B?WXhpS2l1WWJYaGNBTFhzTWYzMEJhMVRXQ2JXdWtzV1JWbUI5ZGF4VFVJb0xH?= =?utf-8?B?SmE1anJKazdJb1VESi9QamttbkEzeVE5blc0RFc1TitZNnZHa2RGMjFGc0pG?= =?utf-8?B?a0lQZkFxa3pBTVdDQ0U3QWdPM2J4WTR5MHN1OVFVVkkxTmNsSXZ0V29nSE02?= =?utf-8?B?YTlPbmNoVHhySUdFSXlPMjRqUTFzVmxQWDZrNWxkS1liWTVJRDJEOHVkTDkv?= =?utf-8?B?dEFzS2U5VnR5NWNCcm4zR1dzZ01pYmxwa3ZaWkM0ODZLZVg5R0FXMjFiWDVL?= =?utf-8?B?MytVOStETXR4bWhwdXBSckp0bnRZNVd6cElqMnpVeWZZVUp3Z3ZSb0QvNisw?= =?utf-8?B?eFhYUXRWWUpJODdhYmZHaTk4bkM4QTRjSlBPUUlKMHdUbXNqN2lzOWdjMDFv?= =?utf-8?B?bUpqd09HeFgrWXpPVVZlZmpVQ1pJeGdTL1A1NmxUcGlJVXl3YTFSYnRMeGt4?= =?utf-8?B?Q0ZSRnVzZUV4OFNZaCtyb1d6eGl5Z2VhN0ttWVRnWWhtZkNMTVFUSFBnRjI5?= =?utf-8?B?YmxhME8rVGFXOXJRK0RrZTVYSno2NDNUZDZWQ0Zzemw3SW1wdGhFY1VrRmVX?= =?utf-8?B?aCtzK1Izb1dvS1NoTi9QdzFCOUd3Y2pSaDRyOGErTFo0TUlpd2kybXpYUDNB?= =?utf-8?B?dm5XYXRYVmxVaDQ0Q2VzUHJHWE9vSGliRUQyM0Qya3NHWlA3UmxQRytWUFFF?= =?utf-8?B?OVpYNDd6TlljazRHaHVxbjZiVnVtd2M4RHNWb0I2M0ZqckJWUktxaUlQR2xM?= =?utf-8?B?THEvTVpXSmE5VTc4MWVGOGgzSTFTWnZmRGlPL253ZXhCYmZyR3dzNmgvVjFl?= =?utf-8?B?TjVhaW5nYXoxNEdpbktzN1laY0xGUEg1ckVOZWJVd2JpRVFWb3ZndXpBQm1T?= =?utf-8?B?dTZreE8rSU9ndGsrRHNwNEJ5RkkrSjc1VUU2WHZEVytlc0VXa0gzVkFVZlNR?= =?utf-8?B?RkR0cmhIV3pGWXFIMEgySWZ2UGZNNTZ6Ti9xcXpQa1FmbndRMUIrSWRMSW51?= =?utf-8?B?bEdLT1VWVmduQit6RnRGSmwwS29NWm5vSHdxd3VQdlk4T3BuVlp4WkFmcDBs?= =?utf-8?B?NVB4ZTJSemEyRmZKb3pFbWU1VjlVREg5TllTYnZFdVVoOGxEMXB5SW1SUm5O?= =?utf-8?B?ejNsYVR2OWFoU001eG9XSmxZWDFJZ05pZkx5VVBTNHBIUndVZ21PTFkvVi9U?= =?utf-8?B?WE05cCtrOFR1RlpkL0tlUlBaUFJwOUNSUys0S0JKTWdoWnFJVGk4KzY2WTZG?= =?utf-8?B?OEQ4TkgrTDdFR3ZySXRwN1NNeldZNThnZnVyWi9LcU01bkR2cXN4RzA3RTR1?= =?utf-8?B?MEJqSWt2Vno2MHlYZ1lrc3VBdVNCUFh4a2ZXc1l3bS92TmdKOWNyZmRKNnF2?= =?utf-8?B?dXYrMkYvUzZRUXMwVE9ncmlwTndSL1FuZktPQkU3R2VTRStxL0cva2Rnc1Jt?= =?utf-8?B?Sm0wK0JHQkNaYjlucmkvR2dvZUR3NTZtdnhhaWJ5dlhmNFdtSk1XVUZFK1RF?= =?utf-8?B?NUtrZTEyOWg3a1hsWlB1cFZDeG5ycUMyTkN2RTJEL1M5LzhpTEVsZDNUZmk1?= =?utf-8?B?aTJGbHJFRTFCdXBjcUt4T21uVGNZaG1pY29NZ0tFUytxT3JEN3QxU25DaWxh?= =?utf-8?B?MjFTRUQwQW4rV2JuT3RrK3gzeEp4U3k2azhZTHVsamR6REVZaDZSalh5Y0xW?= =?utf-8?B?NlZnTDBsRWdvVXo4ejBabkVqKzloQURhRlQzQTB3MVEwQmZHeUlsK3lhaXJz?= =?utf-8?B?TjRVMEtkcGhCbXdwd1R2L0ZzVzIraFZJTmtmV205cU5WWURHNzJscGdIU1lR?= =?utf-8?B?ckxTTC9KczdLcmhoVWVkdUdnTnc0c04wUTRhSmtaYzI4aHd5L09MMFA5MzVB?= =?utf-8?B?Ymxacys5d25qanpGRERad3VJWFlucmg0REMvV0dadFpIVW8zOTNrTVk2SXlD?= =?utf-8?B?d2pUYWl0TXJlSW5TWjArbGRmUUFML2swUERJS3R4dER5UTNZRHZLUGk5cXBR?= =?utf-8?Q?0bqjsYAFtoosLPrU=3D?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: lavainternational.in X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: KL1PR0601MB4433.apcprd06.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: fc00be5a-d90e-463a-5fd2-08da24120370 X-MS-Exchange-CrossTenant-originalarrivaltime: 22 Apr 2022 03:41:41.1429 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 03a36e9a-dbc1-4205-958a-ebbff39814e8 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: HoWpf/Dy3VHcgC6tZZEj/D84kBPA6OeeCCfrhVqi+u1DqAATCgUzC9G7Xwt5ml2YvRbfPVAWPn7Rior1qpCCM8/af/7cLS9TiyCmRRbszuU= X-MS-Exchange-Transport-CrossTenantHeadersStamped: HK2PR06MB3348 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk RGVhciBBZHJpYW4sDQoNCldlIGFyZSB1c2luZyAgInBnX2xvZ19hcmNoaXZlIiBmb3IgUG9pbnQt aW4tVGltZSBSZWNvdmVyeSBhbmQgRFIgcmVwbGljYXRpb24uDQoNCg0KUmVnYXJkcywNClJhbSBQ cmF0YXAuDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBBZHJpYW4gS2xhdmVy IFttYWlsdG86YWRyaWFuLmtsYXZlckBha2xhdmVyLmNvbV0gDQpTZW50OiAyMSBBcHJpbCAyMDIy IDIxOjM1DQpUbzogUmFtIFByYXRhcCBNYXVyeWEgPHJhbS5tYXVyeWFAbGF2YWludGVybmF0aW9u YWwuaW4+OyBwZ3NxbC1nZW5lcmFsQHBvc3RncmVzcWwub3JnDQpTdWJqZWN0OiBSZTogSHVnZSBh cmNoaXZlIGxvZyBnZW5lcmF0ZSBpbiBQb3N0Z3Jlc3FsLTEzDQoNCk9uIDQvMTkvMjIgMjE6MzEs IFJhbSBQcmF0YXAgTWF1cnlhIHdyb3RlOg0KPiBEZWFyIEFkcmlhbiwNCj4gDQo+IFdlIGFyZSB1 c2luZyBiaW5hcnkgcmVwbGljYXRpb24gYW5kIHBhciBkYXkgKnBnX2xvZ19hcmNoaXZlKiB0b3Rh bCANCj4gc2l6ZSBpcyBpbmNyZWFzZSBhZnRlciB1cGdyYWRlIGZvciBQRzExIHRvIFBHMTMuDQoN ClNvIHdoYXQgaXMgcHJ1bmluZyB0aGUgV0FMJ3MgaW4gcGdfbG9nX2FyY2hpdmU/DQoNCk9yIHRv IHB1dCBpdCBhbm90aGVyIHdheSB3aGF0IGlzIHRoZSBwdXJwb3NlIG9mIHBnX2xvZ19hcmNoaXZl IGFuZCBob3cgaXMgaXQgbWFuYWdlZD8NCg0KPiANCj4gUmVnYXJkcywNCj4gDQo+IFJhbSBQcmF0 YXAuDQo+IA0KDQoNCg0KLS0NCkFkcmlhbiBLbGF2ZXINCmFkcmlhbi5rbGF2ZXJAYWtsYXZlci5j b20NCg==