Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tdtBW-00AOTU-Mz for pgsql-admin@arkaria.postgresql.org; Fri, 31 Jan 2025 15:43:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tdtBV-001Phh-K2 for pgsql-admin@arkaria.postgresql.org; Fri, 31 Jan 2025 15:43:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tdtBV-001PhY-37 for pgsql-admin@lists.postgresql.org; Fri, 31 Jan 2025 15:43:57 +0000 Received: from mx0b-000e5c18.pphosted.com ([205.220.181.92]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tdtBP-002YVo-0Y for pgsql-admin@lists.postgresql.org; Fri, 31 Jan 2025 15:43:55 +0000 Received: from pps.filterd (m0285255.ppops.net [127.0.0.1]) by mx0a-000e5c18.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 50VFhm5D008284; Fri, 31 Jan 2025 15:43:48 GMT DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mdlive.com; h= content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to; s=pod0510241234; bh=29OPDXNq5JQN8uyPibg0 dgqeKhI6WKCprTi/OXNARwc=; b=revlGCfB9NHKDR4DStSUZIMay5tLCm1aFblA KKaUUBs0LY0JcZZl02lA76ZJ31VAXoVGRbJZktVL+N9jYEu5IE6O/g6zpPrUJXr9 /6Zeqsa4LCmh8gbmxJfl/nMi9lVEmvlw2vA0Qr5YJS5pdMofqNqbqYpsMJ49aUgN WQZvNlgXD0vxF14Pxknqff/KokwF31cWYBWuT6XVAFCK0zj2xu06MDlyqzjFnALO 4IuujNlQcQmvaDDHiJYrUsmKlU6iJFijGURyreQMfnAQBuvmBa2+PhvgCOF1fc/I 5c/tU9o6+/i9fUgAuwmg2uqdQHhE/3AMKCkrNBVONmc/Z12/jA== Received: from eiaappxp0012.gid.prd.globalcore.com (lyncav03.cigna.com [170.48.19.151] (may be forged)) by mx0a-000e5c18.pphosted.com (PPS) with ESMTPS id 44h1djg019-7 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Fri, 31 Jan 2025 15:43:48 +0000 (GMT) Received: from cvlappxp20750.internal.cigna.com (HELO CIWX9MWP0074.internal.cigna.com) ([10.36.52.82]) by EIAAPPXP0012.gid.prd.globalcore.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 31 Jan 2025 15:43:29 +0000 Received: from CIWX9MWP0062.internal.cigna.com (10.44.168.130) by CIWX9MWP0074.internal.cigna.com (10.44.168.150) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1544.11; Fri, 31 Jan 2025 10:43:29 -0500 Received: from NAM10-BN7-obe.outbound.protection.outlook.com (10.48.135.4) by CIWX9MWP0062.internal.cigna.com (10.44.168.130) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1544.11 via Frontend Transport; Fri, 31 Jan 2025 10:43:28 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=twXlX+kLNOw0tOoxOgXVBb93DuDg7Ug2xQpeLzQrXceL9lmHqh8rpi0XdhNxnA7gUG3Yfhr34oLaQoDpSNKf+qILDPXYFeFQDH/mFIa1tZfGCx0dZYW0EN+ELJCT/zRYOOvab3Clixy7vY0ca5CD1/KzNFTSOQkfo35ePNDog5BaIZianhxVqV3lQR69K1DiaxA6YK55Fj6Nwj1mBm5RVMW5aG5f2oAV9Km0gJZXd5Os0Ah5P0cdqO0fR9Ff094/IZeWaZI7X1GCNrlkIgd0MtyGdliFcu9vNVnvGD7vhPsKtSI9vKF+X82V5430jy+ahxlscE+/Ug0NomCL0in5Jg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; 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=0WWxkGwZdI4vmNQuibk/QmE68WJCot2VzMIsQuFcyKk=; b=GfnNatTfpzwkUtqBS7Sjg155KdsEO5dGlwYUR5ui5aUV3cVmZdFxgExFOwRKIdCI6ASKqk1pHvYkr3ZB8YT/e4VPa2mS/+Lw28VuHXbNzj77KhOhaULl2iTxQqtcLLAMLGxIa5cydiamk8oQtBvu6WUnE0CnHr8oRXI1/DV/lRDNXSYZ4tj50t/wPU+dBujCG4IL8OmjdmYK+sfuRZtG0y/l3Zpons0cdjuBVhMJMlnRXswcnxJ5njBrKJse/8upO700ae1HoHSfSe/TjA181J8aGz234/+oXrYS9WxQZWI5nziNJp8IRnDHPhxuu9/ObgIDTCiIt9FtueqXL4/roQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=mdlive.com; dmarc=pass action=none header.from=mdlive.com; dkim=pass header.d=mdlive.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cignatlp.onmicrosoft.com; s=selector2-cignatlp-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=0WWxkGwZdI4vmNQuibk/QmE68WJCot2VzMIsQuFcyKk=; b=PqPa8d38SULk4Vfm/cFn5DL8fmVe3hxEfibhgODdFHxUp2yHjrFiXmHv93oweZM8bw4CndGPTNoWBdmWNXL0wW7CVDDl0hNk22+KGHBV28z60wY4RBblBRe+cdE2qYTV6EetAEhlm6WpiXj3IXjq+F2NU5YpPLdPU05J2SsKTLc= Received: from BYAPR12MB3253.namprd12.prod.outlook.com (2603:10b6:a03:12f::21) by MW4PR12MB6803.namprd12.prod.outlook.com (2603:10b6:303:20e::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8398.18; Fri, 31 Jan 2025 15:43:27 +0000 Received: from BYAPR12MB3253.namprd12.prod.outlook.com ([fe80::a883:947c:b738:70b0]) by BYAPR12MB3253.namprd12.prod.outlook.com ([fe80::a883:947c:b738:70b0%3]) with mapi id 15.20.8398.018; Fri, 31 Jan 2025 15:43:26 +0000 From: "Wetmore, Matthew (CTR)" To: Fabrice Chapuis , "pgsql-admin@lists.postgresql.org" Subject: Re: wal buffer optimisation Thread-Topic: wal buffer optimisation Thread-Index: AQHbc+7n9JGIORhC2USM7pQW+oNCwLMwf8CA Date: Fri, 31 Jan 2025 15:43:26 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: BYAPR12MB3253:EE_|MW4PR12MB6803:EE_ x-ms-office365-filtering-correlation-id: eb118474-bf14-4c57-437e-08dd420e007f x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|376014|1800799024|8096899003|38070700018|7053199007; x-microsoft-antispam-message-info: =?utf-8?B?OHM4aFpBSkpQTkU4cmh0QXJSQmRQRE11RzN4UUN4dGdyc3R1NW9tSE9GMlpn?= =?utf-8?B?KzBVOE9TcXYrdEVzckR3bzc3Y3VXNk5ZTzFLR0huRFhiZHV2YnVQamhmTVM5?= =?utf-8?B?ZnFDYUVPbTVrZng5cFpHVkR3MnJ2VU5mTW1BMlhtS0Y0TFBXdGF6dnB0eUxk?= =?utf-8?B?RjY5Z0QyL2hkSlQ5aUhBb3hRU0NISmJ4eGZocDFBZUFuR3A5eEtCMnZ1d1k2?= =?utf-8?B?dzdOT1dSMGFKL25nM2hIeUxFbG40bVFLNk5PSkF0SnhuTmVOUzdZSGVhaXkw?= =?utf-8?B?bENyNjdoNU45YVVnVWR1Q1pGcFVjQi81VTd0QjQ1RzJIK3MrT1pTamNJdDVQ?= =?utf-8?B?aHhuU01NcjRoOEJnVk5zZGJ3RVBFVkptL1I1L25ON3JrZzB2KzVralRYQkxK?= =?utf-8?B?VDd5YWVJajZPQ0xpMXRFS0V5UEQyRmpObkJTRDNxbHFFVHlVV05BVEpPd0Q1?= =?utf-8?B?UkFLTTU3R1o1eXBwaXFSVWJKNjVQUEtqMWMzTk11eWhxaDRFUUE0SUsyUmpE?= =?utf-8?B?RUZ6ZTdmWmdEU3BGMnBMNlBISEhHbS9Oc1lnT3RVTmNsL2M0SXdHUEtTeG1C?= =?utf-8?B?THpVdmRhbEpCbUM4dUw4K3RqY0Q0blRZMU5XbGtwa3VKdnFrOXJTUlZxU3RS?= =?utf-8?B?VDV4ZlZMdDhVMXU0UUEraDlUV3BTQ3RWdXJGaFNlRFZ4Ri9SY3libWIyZFV0?= =?utf-8?B?WUVTWnNUQWJFdzd2NEloMHVBK0Q5Zlo2dDRTU2MzVGZ6WjdqRTdUc0pkVm5u?= =?utf-8?B?dXB0Z0RzbUZ2RlNwVWJtRkw3TlFLUk5udGV6L0FMUDB4cUswV2QvY0xvdCtB?= =?utf-8?B?dlcyL0RZNk1ZMHhhc0FOdE9taENuWDN3b1N2blI3bnlaU0l2ZmlmM1dwV240?= =?utf-8?B?dDZud0dVeVBlSDVERVk0V1VwVnFtNXYxMnhKQ2xnc0ZOVGJiaEl3VmVSUDVt?= =?utf-8?B?Z2Rqd3lJLzVVWS9jS0F0Vkt6QWI1R1hPUHhHbXFHU3ZQQnZHZjlLQXJkQ092?= =?utf-8?B?VkxCbmNjQmU5enRHSEU4Sk9lazVuQTR5RWZ1K1dGVk5PcVdSazQ0RWFreFo2?= =?utf-8?B?TkJVNjBiMXdQSjdZT21LMTMvTWlncW9tc1RmTjlrUU1jMytHOTZTVWlxN21o?= =?utf-8?B?SGUyQTBudmFVVUc3UTZrZWhSOW9HdU5sTDVQK3FCeXVYNjFuYjNvR1V6eENK?= =?utf-8?B?NDJ4QXVzZ1dMUE4vcHdxZ3NYRyttMjRxTDhHYUhoUU1aQU1SVDJoYVlocU5l?= =?utf-8?B?YXJ6dGord0VtaFRHZG9nZWNJdm9UMnVIdHVyejljVzdkaTF1ZVZRa2Q3NDRr?= =?utf-8?B?dG82SVdrT2dnajdrVGNsVmZ5aW9mY0ZRRVV3VWVSTmdrZlJOMDJWVXppcGEz?= =?utf-8?B?L3RXZmpsL3JleU5xQm9yYUlhOGlBVTg5b1VVU2tzMnVkb2dQa2dpY0NiKytO?= =?utf-8?B?RmpJQjBHdjExZ0RJSFNEbkM3aEgwK1V4eU5sV0VoWTVEVGFWRU1HUlRqbU1t?= =?utf-8?B?d3o2clM0RnUwQmdZWlV5TnVuR1FyNGpodFMwTGYreEVEOGp1TEJ1b1Brc2NB?= =?utf-8?B?NWhvWmRBTW91c2d4K29zdm9lMitGa2JBZkRZSTJNUG5yZXQ2UUJ4TUNnZkwr?= =?utf-8?B?N1hXdkY3UWpReGJXaGVBTmNrT3luQzhCN0h4ZXZNeDZSeTVPSnNVVjRVcko2?= =?utf-8?B?dEFDeGpsSlBpUnZvMzd5bWhKRHd3QWFLZzlSMWJNeXVBT0JxZGZnU250Z1ZT?= =?utf-8?B?SDY0UzR4QzAydk5TTGtMd2FnV1VDWDRnc2VrUmtuT1I2MlBuSnZFeTRyQjdt?= =?utf-8?B?Nm1xdWFYYW5GTG8waHNUUkdSVG1Cd3RYMTd1dkwrZzBma0ZJbmwraDZmM1BD?= =?utf-8?B?VWF0U3FMaVlrcU1ITnZ3OUdMZlRNSHpVUHhOdnJFelg4dmxGMEZkdy9CcnF4?= =?utf-8?Q?aN3Rp33rCOnnNAT7lrdHH8LBoWV/fdee?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:BYAPR12MB3253.namprd12.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(366016)(376014)(1800799024)(8096899003)(38070700018)(7053199007);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?TDBadXhDMkd5RFVWT29taXJYTzQrU3Zza0FNK05ML2tzUFFHMTQ0Q1BFbW5n?= =?utf-8?B?OGVJT0FRcDBEL24xRktSRExLOUF0SXVaZ29lQ0R2ZFBJWU5lRk9ORWtuVVJD?= =?utf-8?B?eGYwZGZHT0xkeU1tLzB0ZkpNT1FEUTVseHArVVpkMFdOREV1NEQ5SzBnV1Az?= =?utf-8?B?T1FsSXMrQmRpUWlyQWNJczJtMlBNZ1FEalp5T2kyemtab2ptQ21pbE5KclIx?= =?utf-8?B?SGE3RE1pRzR5Vyt5WWNqeGgrZ3ZUMExlekNacG5xQ3M5bStvTTRvcCt0Q3BU?= =?utf-8?B?M2Y0djN5V0NxWExPSCtDczkxS1JzdjZrWnQ3bUVSWUFLek9HbHVDdnk3TEMw?= =?utf-8?B?UU9SQTZTSEZsZWJDckl3LzQ2YWd1eno2NEVaSExvOTN4ZXNCczlmcFo4VlN0?= =?utf-8?B?YkVPbmF0dnkzZVh0cWhubFVxZFBiVy9hbXFJMlliNmt1c2tHWE5MbEFialF3?= =?utf-8?B?WllDalhKQVRLRy9HTklxUjZNUHBKYXRMN3RvUU95ait6VnFtY0xqWmc0cmRC?= =?utf-8?B?WnVnNjRXWGJuS0xxWUVBUi80MjRvUFUyYk41WUd5SkZxOWFWSThFa0Z4cmNW?= =?utf-8?B?WkdFVkluc0lHQzJGOHBjeFV5b1pEOENvRGg0UTJYWHdTbUJFdmJTRXR5Wm1K?= =?utf-8?B?Zk1XaEhWWkpJMGZXVU9VczNucVdlSmlsc2E5UXlGNDRSQ1ZhdXlPZnZTZEQr?= =?utf-8?B?QURDY2o4LzExLzRHNDFKbkt5Q2dBMXRsTHFDZ2pjN3dLQWlCOFV5MEU4WVBa?= =?utf-8?B?c2xFU2hMTFVoYmU1bmRYZUVkanpYcHNycUYvczZBUjRTOGRkVGZoRjVvQ3VB?= =?utf-8?B?Ympybm9sYlZmTUJqTXRqVXFGRm5VZTgyanhvTjI2enJueTNHOUtNQjEwZk5w?= =?utf-8?B?VkVBWXVzUmVqem1uOU42Zi83b05XTkwxL1JBR25LSUVjY1BWSFpYMENzU1li?= =?utf-8?B?Rm1RbVIveC9qcitCRWJ0SHVTK1o1WFJRc2Jsa3lxdW05Yit6T2tFUFBWZXA3?= =?utf-8?B?QzViMUd4UmRSR1N4b0NicVZ5SGxGVUVDaEd5Sy9BY0YrOTdyMlV1UlZOUXpN?= =?utf-8?B?L0wwbWN1MWc0UFBuQ2lwazBLZ1ZDek93U0ZPRjlYZ1NDSDc0bHcrOFhzUG4z?= =?utf-8?B?UCtsc1Q2T2EzcWUzcHhsdkZuUjlGbW15MXJLbkR0ZDJzcHg5VDE1SUsyWThS?= =?utf-8?B?NnJlcEFOcVNWRzc1TzJhTUFvTEFJNWFjNWJ4dGQrWnRZWDZIZWJwQllsUUtI?= =?utf-8?B?SUJLYXowbmZNMDlVOG1DUEx5YkNOcUorWU1TRFkxRHhpNnI4cWRCdHZjN1Rm?= =?utf-8?B?RlQyYjJGR0N1M0R3NTVWb1dXY0owNUdnVTU0eVhVQ2xjYXFKK0EwWE95UlQy?= =?utf-8?B?RXVPbW5MSk9XMExjWmZOcGlubGRSM0o0Vk9JU09tWTZHYndONEo1RThPaDdX?= =?utf-8?B?Tk5HWG1SZTkvczBTOWY4c1lQNXJUNTFXaTRZQlJ6bENOeGxRbWVtYWMrMkxV?= =?utf-8?B?MlFwNXZnS3BFUmNLRnUvWWdKdnl1ZDlleHJIaWZNUUg1dUQ4dkVNa1dQU3p1?= =?utf-8?B?M2VCTzFMZnFsdkVKNEI5SjZOMU5mS0IwckdBQ2psbmRRc2NwbTh2V0dJaFpZ?= =?utf-8?B?UHdVMnc3ZW9OeWVENHFqTkp0L05XSDFwZUNyU3ZwUWg4UmdTS0pESGxVeUFo?= =?utf-8?B?ZmRqU0NOUDc2N2VpVTFPUm9hckVtNHphd0NCSmFwZ3UvRk1RbGJDUHhUL0sw?= =?utf-8?B?Y2VtZzNKNlREdE9JUFNFVjRNZFZ2M0NKY20vaGFiUmJ2T2RONG9LT0lndWp5?= =?utf-8?B?QXJPNWtoK3VtNW1vWmRQWExGN2FPS2xKRmVqVmM3M2NlVzRvRnhjSFh4dmxt?= =?utf-8?B?SlV3LzdOa3FoVmhGS1ZmNzFUZlg3am96UU4wWWRDWHg2QnpiUGFKeXA0akRs?= =?utf-8?B?dUFMVnNtbHVlQmh2K3RHQW9QdjdneVZ5RzJDdVJsZ00zVUtMMnM3czRLNTcw?= =?utf-8?B?YnR5ZzV6Y3lLWmFEZ0drZ1RPUDVIdW1uQmhyUDgwUTY1OGFBK04ybjNwSHE2?= =?utf-8?B?STd2Q05iU1QwQ3oxSS9TR2RubVZEdzRRN0xyZ2s4OEZDNmxHUE1FVk9DSlVW?= =?utf-8?B?dUYrOGdiNGZaQWRZZ0FKb2tRTERKTjcwSTRySWFIZzVwa2ZyMjNZUTFaU2RZ?= =?utf-8?B?SWc9PQ==?= Content-Type: multipart/related; boundary="_004_E19626336872423CA3399A70A6BFE3EBglbcorecom_"; type="multipart/alternative" MIME-Version: 1.0 X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: BYAPR12MB3253.namprd12.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: eb118474-bf14-4c57-437e-08dd420e007f X-MS-Exchange-CrossTenant-originalarrivaltime: 31 Jan 2025 15:43:26.1567 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 791b26cb-3fdf-47c3-b85d-bd9f037e3e7f X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: Hwa7S9gSKF7zntNDTCcc3RGtCJN6v32hm89hJwN2P5+pzCgHleCkr01P/E67n37+krDHp8j+uXMVVWaiJ8FZpA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: MW4PR12MB6803 X-ProofPoint-Routing: 000e5c18 X-CFilter-Loop: Reflected X-Proofpoint-GUID: H0gLQNUIpQmH3UBsglpaoyTgdnF5OBBO X-Proofpoint-ORIG-GUID: H0gLQNUIpQmH3UBsglpaoyTgdnF5OBBO X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1057,Hydra:6.0.680,FMLib:17.12.68.34 definitions=2025-01-31_05,2025-01-31_02,2024-11-22_01 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 suspectscore=0 adultscore=0 bulkscore=0 spamscore=0 mlxscore=0 clxscore=1011 mlxlogscore=999 priorityscore=1501 phishscore=0 lowpriorityscore=0 malwarescore=0 impostorscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.19.0-2501170000 definitions=main-2501310119 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_004_E19626336872423CA3399A70A6BFE3EBglbcorecom_ Content-Type: multipart/alternative; boundary="_000_E19626336872423CA3399A70A6BFE3EBglbcorecom_" --_000_E19626336872423CA3399A70A6BFE3EBglbcorecom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable One of the things I do=E2=80=A6 SELECT * from pg_stat_bgwriter; checkpoints_timed | xxxxx checkpoints_req | xx checkpoints_timed will be how many scheduled WAL checkpoints you have based= on settings. Checkpoints_req is how many extra checkpoints were needed due to over capac= ity/misconfigurtation Divide req/time You want this ratio/percentage to be less than ~5%., otherwise, you should = be monitoring WAL activity and adjust the other settings to avoid checkpoin= ts_req. -- Matt Wetmore Data Engineer Braze Certified Architect 415.416.9738 [signature_4160879279] From: Fabrice Chapuis Date: Friday, January 31, 2025 at 6:46=E2=80=AFAM To: "pgsql-admin@lists.postgresql.org" Subject: wal buffer optimisation Hi, It's hard for me to know if my Postgres 14 WALs configuration is optima= l postgres [2854804]=3D# select wal_buffers_full from pg_stat_wal; +------= ------------+ | wal_buffers_full | +------------------+ | 910589 = | +----------------- Hi, It's hard for me to know if my Postgres 14 WALs configuration is optimal postgres [2854804]=3D# select wal_buffers_full from pg_stat_wal; +------------------+ | wal_buffers_full | +------------------+ | 910589 | +----------------- (1 row) postgres [2854804]=3D# show wal_writer_delay ; +------------------+ | wal_writer_delay | +------------------+ | 200ms | +------------------+ (1 row) I got some metrics from pg_stats_wal view: 15,702 buffers full in 24 hours= and 1,243,890 writes in 24 hours, are these values indicative of a perform= ance problem? Regards, Fabrice --_000_E19626336872423CA3399A70A6BFE3EBglbcorecom_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-ID: <96B1D98A717B5C41B2A0214ECF355F39@namprd12.prod.outlook.com>

One of the things I do=E2=80= =A6

 

SELECT * from pg_stat_bgwrit= er;

 

checkpoints_timed &= nbsp;   | xxxxx
checkpoints_req       | xx<= o:p>

 

 

checkpoints_timed w= ill be how many scheduled WAL checkpoints you have based on settings.<= /o:p>

 

Checkpoints_req is = how many extra checkpoints were needed due to over capacity/misconfigurtati= on

 

Divide req/time

 

You want this ratio= /percentage to be less than ~5%., otherwise, you should be monitoring WAL a= ctivity and adjust the other settings to avoid checkpoints_req.

 

 

 

-- 

Matt Wetmore

Data Engineer

Braze Certified Architect

415.416.9738

 

3D"signature_4160879279"

 

 

From: Fabrice Chapuis <fabrice636861@gmail.com>
Date: Friday, January 31, 2025 at 6:46=E2=80=AFAM
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lis= ts.postgresql.org>
Subject: wal buffer optimisation

 

Hi, It's hard for me to know if my Postgres 14 = WALs configuration is optimal  postgres [2854804]=3D# select wal_buffe= rs_full from pg_stat_wal; +------------------+ | wal_buffers_full | +------------------+ |        &nb= sp;  910589 | +-----------------

Hi,

 

It's hard for me to k= now if my Postgres 14 WALs configuration is optimal 

postgres [2854804]=3D# select wal_buffers_full from = pg_stat_wal;

+------------------+

| wal_buffers_full |

+------------------+

|           910589 |

+-----------------

(1 row)

 

postgres [2854804]=3D# show wal_writer_delay ;<= /o:p>

+------------------+

| wal_writer_delay |

+------------------+

| 200ms            |

+------------------+

(1 row)

 

I got some metrics from pg_stats_wal view:  15,= 702 buffers full in 24 hours and 1,243,890 writes in 24 hours, are these va= lues indicative of a performance problem?

Regards,

 

Fabrice

--_000_E19626336872423CA3399A70A6BFE3EBglbcorecom_-- --_004_E19626336872423CA3399A70A6BFE3EBglbcorecom_ Content-Type: image/png; name="image001.png" Content-Description: image001.png Content-Disposition: inline; filename="image001.png"; size=8286; creation-date="Fri, 31 Jan 2025 15:43:25 GMT"; modification-date="Fri, 31 Jan 2025 15:43:25 GMT" Content-ID: Content-Transfer-Encoding: base64 iVBORw0KGgoAAAANSUhEUgAAASwAAABeCAYAAACZ4CkLAAAAAXNSR0IArs4c6QAAAIRlWElmTU0A KgAAAAgABQESAAMAAAABAAEAAAEaAAUAAAABAAAASgEbAAUAAAABAAAAUgEoAAMAAAABAAIAAIdp AAQAAAABAAAAWgAAAAAAAACQAAAAAQAAAJAAAAABAAOgAQADAAAAAQABAACgAgAEAAAAAQAAASyg AwAEAAAAAQAAAF4AAAAAghYDeAAAAAlwSFlzAAAWJQAAFiUBSVIk8AAAH3FJREFUeAHtnQnYVVW5 x1EDUUwlkIwrQqKWOGBpeMNSKhwuWJZdtRQDNFNpQG9BDmjOA1Q4hXYLSVNSHG6ac9wnjJJSNCVT hEgIR8REA03M7Pc/Z63Pdfa39z577bPP+c53vvU+z/+s6X3X8K613jXsfc7ZYPLJp+3erVu3vuBN kETdSXhq6oXnLUtiaEQ8dR1COf1BUl1Vz9duu/nGhYuXLlmfp06UsRlyewDllVROlqwl/3cgva3K IlBPnleOGzyc/HuBqF56ELd0ix8uW47b1EQbNE4/BKJtsPV+iHastQHXRXYQ4Q+D54H6Jo6ki6fJ 44m4xEbFUdeelKW6xvWXqqFxuTVYQV0fUkQ1Is+d4NkGJOmuWhZFpEu/f6DOq5MyY/4dTdqlJv0t XOniZ8yhcYrbAIZXcDdXIAO9Cs+pCP8gA28hLNRvIBnNATKsanAW+gB1XJKF0eWhrF8SHunGFeTX IFkDloP7wGzq9whuQ4jBKiP8MnhXQoH/Il6L0cEdPVnj6mcm8L2k7Q02jOMxcUdR/2vj0sljX+Ln xaXFxL1E3BnkNSMmra5R1PN2CjgAJPWVW/4l1PFENyLqJ78xxF0M+kTTOig8iTp/N65s5t9U4ieB xWAceAp8CyhuJXNmWxksrUiy5D40F+H9fATy8FK3ryJ3eQ7Znanf41nlKEcTWiuvrx6yFhHHt47I BeBc6iojVjdi0PYl8+dAtUkgw3UoA+qWulXGM2NT96cR2ziD6LHU/cdJfOT1DGn9k9Jj4ueT3z4x 8YVHUbdBZKqJmqWdKv+foDf10/yNJfKUwT0hNrHjIk+jzudHi2cO7k7cH8CVYD64EEgXZ4PbwXLw f1qttO3ypZEUcIOvkA8/+Y+CP4+xUjHqTB/SbqeRxkp1U3kjwTza+gKQca4X/SNjxhoPszPyNort 9xSUdRJXa+fVnpX+OJP+ek+ZvOx/9GinylhQxViNhqfZjJXqnTQ31TfrWbxV5yvAk2A4kA3QXLkN jNYAzUuHMckG5xXOIDcrA0/NLLTh82RSz3ZkqWM/mC6nLmvBEVkE6sizsVmZ61hEtqypxxg4t8vG XZ2LCX4qXG9U56zgOJR6DKqIKThg9K1dvg+dU4VZO5TORJqD2mGKtPDsBnSX9ao5LWmD1KMWg4V8 t7ocHZi0OstqEjeCPt2IQjKWoZXkOtr/Z+A7gDMWkYlNO79moC/UoRL3e+apOXKGp4wv+1GeAs9i fHXfmkY7pCU2YZpOehr/luTXvaPu2EXb6qNWg7UbE0s7lKJpYtEZpuTXOyWto5K02vwd3XbUbus9 HdXwSLlbRcJFBM/KkclBOWQyiZhdpO/ilHq0JU/ll/QkNFO9OoDpAcp0Tzp3sLNSOwYwD7R5+RxY X6vBIo9u0/VRFFE57dp6FJVfhnzy3OFlyLYQFu22dJ5vNOnyvRnI9/hWtc7sTO6D6S9VGSsZtsII 1Osh09cri6oa+qc52qYx6p6oWfowrZ5taRinkn4Z73qlRDbg1yZxGq52k8PAd4owWLKAZ5JZzUQ+ Q8hEljTQOxo4Hr3c8U4w+ArQwMwceZySQyZVBCPYE4ahqUztExe0j2qZmNG05INAR+SBxq4cgF/3 Wbdh1C4swmCRV+ldCbm10s9qzaBF5UfReXW5L2xRfaU2ix2KHqv77t70xKpoOoMMsz4BtWVXu2y3 fJ3OxSDdSaXfC/4EjgPfAluDI0k7GLfqezniyUK9mFA/IdNxWZjjeJDXfY0saaB4DXwOHU1Fx5Pj k0Ospwbmwq8VPSvp6ekEjN2MrAIZ+A7PwOOyZLlsd/mb0Z/6LiDjexWV3iup4qnCSUIJ8WOZUFMo 8OmE9GrRhd6FVSushnRdDuqcXe2yXo9mdXn9fjAAFHEvNwkdz0PHWokC1aaB7yDuY7BUmt4RKsRg Yfx2Iq9BwIdSL9t9MorwriWstmlMFzFOI9mXghvxKXszOy4xa1yRBktl6t0p78tJJuGZyPUDnYHO ymMwaOMoGqdJMqzGRurYvEWNeXR5cXZKD2E0dPm+nYcyPohMX2RXe8gksWos+FzJ6CL9/KTMaox/ nTZdW2MeDRH3UViWCukN+H2zMEZ4Cr/QjOTf4UEZOaCt7ruBdml5aXN0HC7h82qvUu6HlcGqIS3w U6pyZWMYmY2tjethjIp2QvWgou1APepYyrMeFfV6AsPku5Wa1GsbWjfF5c0Yo7XWGK4j8+aBnC7h h9QgH0TRAAZgKo7v5fuhtSqPXZqOor5fRr6o1nJbQb4eBmswk+noLMoxk+4zWXhbjQejpbP89mB9 zrbNyikXxCo1oMt3H+qPwdnDRyCG95sxcWlRL2Fcw1NiNFQPgyXFZ71Avzmtl1o9DaO1jDbqQj6P 0RoWdlmFjJBJ5OL7kqVkaiHfVyTm1FJYK8nWy2DpnkXb7UQiXV/p0UtiXZowWqtQgF7pyEO6uA1U gwbYueiJrxYOH/K9f2rLm92Z3i3yefdKl+16XysQGqiXwZJyJ1bRcCGPh6uU0SmSMVraaernM3zp QF+BwB+rgctiY5Mj+2B4DklOTk35Smpq+0RdthfxVLJ9zp0wpp4Gqwe7qNinWWb31VleY2hIt2K0 DqagdZ6FaSeb56msZzGtzY5BkMHyfQKX+kufcRrDyOndK/cLvnFs0bhw2e5opJ4GS8XoaVZcB1Xb fTlV7FLem3K0th4/wZKjGp1eJHZxTWlVnvfpdPflM+caddnue4eXopb6Jum9Eh/Sfcsi4HOG19ON obYQs+vyeY1B5Ym6wtd2dCc1ttTa7B++F7jZc+5anGfR3ENBVoOir+qcyu7sfA81+T4Rb9Rl+ya0 ZQzteA/wmZtZm65870FX92UVSOLzNVg9Obrsh9HRuytZG1b6zSzd0yA3BLlRSZVJiNcfD/w2Ia2l otHRCnS0kkbpyWFWGpSVMfAla4DJ9AST9nE4dknmapcyjphMBou8fd+90mX75HYl1idiM7L9aX2y bsv1Y/j2aQvl9GRdTWz2+jkM0QVlJ/PndMOpr5X40Hwmse4Wqn1vzyfPZudd4FlB2yeeYoE9RgNX xMSlRQ3GEA1KY3DSfN+9queb7U61GuaVAa6ZfA1WqUCMyJl4dDzMSvrNrF/D7HOs07tJvruxrPVp Zj49ZvchPdwY6CMQeOM1wC5rBik+l++aP1lfOfA9uofL9phuymWwTD7jY/JLi/p4WmJM2iVmdxWT 1NJRS3K0Tr8ZFKgYDfhevh9UrVh2YRPg8Xn3qlGX7dWq3nTpuQ0WxuROWvNAnVq0ivwbdX6vUxNy Z/tMDsltcsgEkXgNnEy0z1Mz/XxytVdLTogvKjF2TmJKF0/IbbCM3j6Fq6Nb0VTLF4OLrkuj8+ub o0Cf1TtH9l1HhGPhclr7uGeL9bpCLGHM1J8+3+jQXU/WY2Zsma0cWZPBMke2qwpWkC7a5xacZ2fK Ls/xbnlnamAnqOslnnVM22FNIS+fp/HhzfYU5ddksJQvxkXb3VUpZfgk6Z9f9/ERaEHerXK0aU0O mSCSoAF2WT8myefyfTN2Ul9OyO6IhPik6HDZnqQZ4ms2WCbvk1LK8EnyXdl88u4svDvlqOhfc8gE kXQN3Jie3C5VF+sVZO62fBagVr5s99llVujRDRRisNgVzSbTWi/gl5FPV71od/tkDzeQwb8Ovfns BjJkGVjQgMaiz+X7rhgovYDpUuLdlsvk+Fv5sl13czVTIVbP1OLTuC/UUKPja5BtJVGft9zVbr0Z H6hgDXAsXI0BepRsP5Qxa82lUw2sSNrdluWxriZ0R122a8HbFfQH3UHRJEP+pyIyLcxgscqv4gXG q6nU2BwVm4v83BxyLSWC/vRIPetXnmzbfV80tXLBra6B78Pi85UVjX0ZrW4YOx0RozsuJSVRR162 608ollMxoampkCOhbSFGZxz+V204o6uLdu9/2smYd2dja3cPkqEB12XgCSw5NMAkvhaxlzxE9fPJ 9g7yyx5yYu3Iy/ZC7YBnu73Y61FR3wv4C7xq3KLM7K6OoGm+x0HdX+nH/wLVTwO+90rHmaroiJWV WvmyPasOMvEVbrCYQHov64FMpXP/Av+ZGXlbnc33i7fSx8OtrpQmaJ/ulXwu3z9ljoM+1y2+RrEJ 1NIxVSjcYJlmHJWxOV/IyNfSbOyufk0DN8/RyAtzyAQRDw3o8h32hR4iQ+DV3VdW6sjL9qx1bBq+ uhgsdk1LaKEu4NPoNvjuT2PoCmkYq1tpp+8Xw6Ua7U7v7Ao6aoI2+twvaU75fFWqIy/bm0C1flXw 2bb65dyt29cQ+EWK0D0paV0iyeys8hgr6efMLqGkJmgku6xbOOa9SFV8XgLNWnMfY5g1z5blq5vB YvXXux3hQjhm6GCohhN9F8hzDFSOi9Gv7goDNU4DN1HUCQUX96KMYcF5tnR2dTNYLa21nI3DUI1C 9HvA59v7caV9MS4yxNVVA3rz/VhQ5JyREQzkoYEile9RbKdmLf2aAsZnYEIr3iJ+I9AbDAZ7Ab3x vDPoBWqlK9ldPVJrJlXkN+QI1BcetdHnPiYtW71BvYIdxfI0pmZNo95r0cnD1G9YQXUMl+05FBkM lr/SZmKsZvqLFSKxCGNV9LEkrmJ9iNSdTdH0Lyb982T6FQzAHUVn3oD8dN9U1DVHM122649h/9EA /Wnxu4O+PyhvWXV5Spi3MkEuVQP6Fda2v0tL5WzeRI23/uB2Jsj5zVvN+Jox0XTfVJQhb7bLdhmT ekOKVf/npmCwcquuoYKvYqze29AS61/YKRgtHZU7G80uoMJd+c32N2vRXzBYtWivMbLaWW3RmKIa XsrlDS+x9gL1BXXdP9VC4c32nNoLBiun4hok9kAL7qxc1e3gBjqDn2Oh7noW1FBXGTs9ceyqpIcv uSkYrNyqq7vgKRgrPWFsZerOsVBPIzsb1XL/pMt2vaPYVSkcCVus5xfTnvdirLrC9wT1peJON3kx OHrCmffyvRZj1wpDvaYf8guvNTTPENAvhx6NoZrbPFUKNUnRgC7fJ6akxyV15ct26aPm43AwWHHD qnFx6ynq9+AbGKp6vwzauFZ1jZJ0+f5V4DOHuvpl+w/Yna6uZXhI2Xoru9VoU48GNbr9q6jbIjAL I1XEI/IsTe0JUzPeV6pOmwFdZMeR0nwo73czfcoo8erynfs3Xb5n/fJ6zbsLj0pKb83U3zr6X4TO TvVoQyyrDJbO47uBaj9trMGwBHQEaWDo0X61e4Me8LwMngVZ6V4YdwTV2p81P5dPeT4DdC+1EPwO I9URdzYq81Ggd7mSjANJDSUZ0RdAmj5uIl2TT32aRvbJk3arjaRzKOzuDAXKeCxgwqa1NUM2mVlU zl1AX616LbNUsYzqE12wa+6eW+vOylZtA+sJbtBA0IC/BthlyfBq4dcOKpG0I0tMDAlBA0EDQQNB A0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNBA0ED QQNBA0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNB A0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNBA0EDQQNBA0VqIPUXRwcPHKSfp+2+bMXyaj9R W2SdQl6dXAMf3GHHHm+uX6+f3db4eYrxs6KTNylUv0k0kGiwMFZ7UsffAf1JwxQG3XmNqDPl6ne5 PwL0w/VpP6Svuk+mXtNwA3lqAD3/HJGDweXo8Oue4rHs5NmbhOvBfsAdW2sIn0E5l+EGChrIrYE0 gzCFXO0/yozPXYK/4DaIaLDbsuWPg3LWn04EitEAxqMfeBE8A7TTidL7TMSAaEKeMGVoR6U/Cdkf qL/eADJUoi3BpfDcUwqFj6CBnBpI+0+1fZ08t2Ow7cAKudSJq7f3Kso7pt6FtHD+W9C2vqZ9fXCT /rFFhqUIup9MtMisAyPou4XK1BwP5+MdBvZnHP2ItGOVFihowFcDsTssBtURZKRVUYNvJdCKeTJo JOlIGCi/Bp4zom9379HD+vPnliLJePk5yb3AW2CANVYSWbx0yXrCe+HV36mJjtHiV/aGz6ABPw0k 7bAmmGxuwNX/Ft4MDgGxOx4G4HjSDgT2LuQW/B8Ar4BfgZMYtEkrPMmxFGtMo5yUPZo41fcXlHFl NF1heE7D0b2Y7lEWKc4SaarzGKAdyQrwPXjs5CJYJviG45sMtEO4g7B080lwPeFSu4k7m/BWhE/A r6PRdNAP6M9Tbyb+DNxYgl98Z4GPgu5AO5RzkWm3q4V3Emm7kDYWv+o1A+jYdwhxi4ibil//SSfa gAvwK4hbj/+XpKtvXPqbAqTruDYYqJ/mY+S+KWODPwuNNExXk//LcQLk92nq8RppG4FdQUW7KF9H SvXTLuBNoHFzOvm1GzemfXoYdBJ+tV96Vv9JZpKVIU16GgdEjwHdeaqP28jITybC9qv6bSJQfk+A 05BR/8US8hr7xwPx66+8HgKXIFMxzoiTjlVXlTWD9HsJz8SveSNDvwycRfw83BI5/PcRP93Guy48 auMIcB482uW2NG0Q1zqUoP9Y08D6hBRIWLsd8R5A+F7cCiL9z0RosD8OZKgk65KOHbsiWzFIXQbr J69n8PcHP4a/6tEBfhmLS8HbYGtkKgYX6TJotwPRjrYOxGtCPwK0k4zSo/Dt7kbCrwvjr4GVYBPQ F4iWwbu9PPBowG4MngTSQ5Sehfc/opHIadBdBOL6YxoyGuRtBL/uilR+VN8HEaf66U9T46itXeTx exiGAU0U3Ruq3i6pz7al7Ap9ugzyk48muIydqE2/5WDlJ7zaWT1HnmvdFOI1cY9244xffToG/tlu Gvx2fKr9Q9w0/OvAh8AvQLQPlN/HyK9tYpPXFcTJ4Ehn6rfDQJRiH+4ga3UY5Vf4Yso5yU2A346h 1SbejiGX7RzkSgsb/HuS8KBJHEp8hREkfQRpvzLppblq/C3rbBhtGUrQ5JHBeQMFzTPpWmlEE8pO u08NbpEGjybtN8AB4BqgQaLJcBconKijBsEaoMn+rZgCVBfR4/C6BtMaK9V9GnDrOxQ92IEgWdHr ZafbAFwNNBluyU0GljSRRJooMhyfBzIi84CoP/neUPaWPwkfgm8qUP0lcziQnCajaBI8FQO/HF36 tPq+mNAUoIn4F/A/wN1tqp7nALeuBEs0mE/V+wQgHUjO9llUByS1o4+YGI0XV7/tGJUO1roJtE1t t8bqAfzSl8LPAunkWni0M3HJ6lntl8zeQO17C/QCS4D6wKZJH+pn5XcjcMnmNZRIGSvpXXU4EqgO oqmmn8ohPgn/CGeYidBYkO4kI6MnOhGe0WVv26ctS+OnD5CuJaf6ydCKpiA3UB50tVCO/NA3y07F p+aqaCW880q+Fv+IOxIeY9p8t9P2n+CfCuzW30mq8GrAaJdjB6W2vY8RJ9nB+LNc3CsP0Xj4v4gb V8cexB9DObPECN0GvgS+AKKTcl/iRBocJSLfq/FsCTSI+0bqK0P2fTACvt1IW4Q/StVe89AA2tYR 0hFSk38EiA7iywxf2+7HhG9B5h78+wOtuHFHgjc4ar0n5ug2HdneyGjnoDusKTE8JJVI+ta908sm rD57Gv+5YCf8/UhbZdLinB1N5N/jEjPE2QXlGsoZ6/DPouzFhGV4ZBx2dtKsVzrbywTuh19tUN+J 1AdumnbuWiy0aCT1653IuP0zG94/IyOjrn66BVjS2BTdisxny97SpyszgZg7nDTX+23kppkI6fw6 /M8DGdUTgV2kNMbVF6NAlOzY/kk0oVXDG7oNQ2n9CGuAiGRkSmQUq4HdC57xJjrOeQxea6xK6UyW S/C8bZg/FieUELcR8b3AxjFQp2qVsvQ94xlA/XTsKBF+HRclr9XfGgal2c6/IlpfwjIMa8QEjSk7 FZ9vwXNeRUz7wK3to7pdYOI2NXrWKq269jfxMrhR+jwR0t2W8EZ3GeJdmGKINheDiLsj6TGJHqI9 1liVeEz71N/S88gkQRPfs0p6YjJt0liy/TM2htEas530tNFJf5fxty1CCpu+swtehaEgbQ4sWqBE u5Sdik/pOW5sTzRcJUPnSDyIfyWw6U5St1+agAxdHGk8WmNVSie8Cs8Thrmtr4nXWFOb+qIvLV4l wn8YHvWrFiQZtC5BtuNtY08xHq1O99tI487HHQG0as8CLsm4iJ4sO+98akKh3FeI2RK8/52URJ/N q7RyIbtnDKcGb9vOh7rqovlZ4jT5tb3W8UZ0TNnpdp9xrdPbeHZH7mz87zNhbdlfBN1NeKhxXadi crsJ+K0+F0TiFdTqKdoAbA00QA8EojVqQ9n7zidxa6nf08QMAOKN9okmTa30XEIG2jFl6TO1Iy/Z BWx5XAa0XzsPGZmNMbo6prk7HIm8qo8IqQ81hh6NxCv4OpCBjBuHL1Feu7YQp91xqQ7IfQqU+on4 T+DXojMcfBVvH/AvsATsA0TWeJZD73xKt3G0lMghYItI4u8I7w0mgHtNmjXmD6YsWoa1dRw7wWyL tKKLShOOjtgN/+t0jhSpwTIC7KHVLkFJGgxxpEEksoaiHEr/lOGw5/h0znLqHBxtpf8b6CmdylL9 RZeWndIA0y7S7ixH4BeSSBM2D70SIyQja0kTx6XX3ECC39XdesPzZgKvT7QmYxol9amV+ZPxuPWz adVcO/7i9GVlNXZUB/WbD22Swhw1CGJNq4MMjOqwnRhFjK9DcK4BvRSuM2n8ymDZBU7F/ac+oIpd ZjmqdT/tgFEHaCejlVx0GGFtOUuE3/hKzkasdrrsq3YscmWsPzpRbXyca41KXFpc3OlETgT2qDgO v3Yz2r24xwMNZMWLrgIzgTVsilO6VsnHwKsgSm06iyZUCf81JX3TlDSb5OrOrtB2J2h5OsL9f1Po RoyT0RFdV9SH9LOJ0G5Wr2uswLUL2WYVjJUBq++/VUYXHoozYraQdxvPy3Jpxw44NwGNo3Xgp0AL bE/wCNA4HAYKIXQ1hzI1VnUlMxD3A0C7SB0to6cdoluX7GBQC2WERDrLawV30xSvwaU4KWo8yGOw EKsP0XE6Pi0idz3hm4473JSknWEbaaKQrkGmlVEvNeqYVXHUIl0GbCq4FcwGRZB2UdKtNZbKc4E+ IN1RDVTdysGKz/4mdGdFbPWAu6MrYicWWyJ1XkrdV5Koxe4M4C4ObTLwaEHUoiKSvjXRtCiIBped yk9k1Ifa2Uhvvu2vzKx6qHfcycHUW3UQ3V12Sk/B1Y9aDNvtLJEZa/iK1Lv0ehiYArYy+dvFwgRb 33F3Mfub5v6QTugJ3hWBVg8pTKQnfgPL3rp9ymj6kt0e67J9mBHWqh6luSbi2IR26Hiptk6OCtYQ brcbQr8LyW+1yXNGNG/qdhlxWiDWwTvPSY8uJk5SO68mVp92scVGfMdkN4w6S/dxJOMvWk1bZsmD q4XlLbAxcnH9pEVD9Bd415a9dfvUyeFHMblfbOLUBzK0Iqv/dn1KO0aQvp+YCia7QTiGfD9j8p5W cBlNn11J8ShZ53F7X3NhUq3pMD1qX2N4T8a1l9tJItH4dh0cZXDCH6YsGdGdnTjrVb17gDnUaamN xH8lMt8lrN2TSC91ttu1EPdZ+DQBxLcM//m4l4PtwfVAu4W3waGg3qRdxxVgFPX4De6RQMe//wUH A9H3y072T54crWACqg0yWNeR90zcP9J2GclCiTz1CsKXyHQE0JecNZ5OAy8CGX610e6U/gu/S9cR kOzpyA3EPRH0BTeCoUA0sezU/fNL1GELShkPVIdrwTAg+mnZKX3ewOfxQEe0Z3C/AlYCzYfjgHQu 2p701GNyma36Jzp2HyxJQIZ/XnXJ1uLY0DTn28Z9EiW0m+CRJt9rwkc58TIgok3KTuKndmlZSQPl HqDJGoVW3nPBBBCl3zoRsx1/1LsdEdrdaAejCfUCkOwA8BY4EF20GUPC1doGS9vKK3+UuhNhB3Jb GmVoV2h3hnvjXw5UF2us9H6Sjlou9XADcX7zUOQuk6Z8rwI6TkRps2hEnjB1/ARydxrZEbjS5RKg fpKx0uW+3jKvMJiExxJvx5QM19+A5Kyx0lvmscdMeOJIVxciOybLofKn+kBk3XKo/KmxIKMjvds6 WGP1W+pwQpmttDOch1+7cFF/cDt4FMiIrQfnAC0WWhDtzhJvW53i6qb0ajTTYbjJ8XcZr1Xc/bT4 TXB2hpZr0GuQr3XO/JcQPhy4CiXYRqfj+yhISm9jxDMDDDcRWuWSSJPAHu1cnkkm8DzudDfB9TMA VxHeihXwJNwvg35Ag+1uMJH0tbguXU1gc7DAjYz4dYQbAh6LxHdjx7OGHY8Gsoz2c266JgP1kG6m gR1N2lO4ekF1ngm7jna3B4Dr3MioH9nRpn0jSdsUXOPwzDL+pD5RWz4JpI9MZMrbE+azwK5Ai4F2 5LNJOw83lkg7gHqOJlGGeRvDJB1+jTR30TBJpRdJteA8aCMc9wL8au+vnDjr1dj6CLjRRjiu7jO3 pR5TiRsPtEA9DS4i3uqKYJmIOxxe6U59qgcJoofBGNJ0n/oyfo2tJ4Clm/HsAubbiIir+smwu0bO ZfmNE7jQ8Qdv0EDQQFfQAIblMvA2eLHZ20sdbzB1Xdzsda1X/TasV8Yh36CBoIHCNaBdqChpV1xO beHPYLBauHND01pHA+ysdD/WC+irYdNap2V+LQkGy09fgbv1NPC6aZLuL5uZdK8muqfsdM3PfwNo t2S/P69oagAAAABJRU5ErkJgggAA --_004_E19626336872423CA3399A70A6BFE3EBglbcorecom_--