From: "Benoit, Eric" <ebenoit@e1b.org>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: WAL settings for larger imports
Thread-Topic: WAL settings for larger imports
Thread-Index: AQHawLxOHBJJQoi6GkK/lG5oQbCPVw==
Date: Mon, 17 Jun 2024 13:46:06 +0000
Message-ID:
 <PH7PR19MB6979138226A0D5CB9120C1A0E6CD2@PH7PR19MB6979.namprd19.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
msip_labels:
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=e1b.org;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: PH7PR19MB6979:EE_|PH0PR19MB7455:EE_
x-ms-office365-filtering-correlation-id: 290cc582-1a6f-496c-9799-08dc8ed3d6ab
x: WNYRIC355
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;ARA:13230037|366013|376011|1800799021|38070700015;
x-microsoft-antispam-message-info:
 =?iso-8859-1?Q?2/n1RJqWeT5ZZECF+thHMGqSHytjFdPxif/LNfgQGYe9L+t/6u67GX68FR?=
 =?iso-8859-1?Q?NsPHRuGu8+xTNObHZCE7g+oxTP0fvbzPA1+ma8+Xkw/nTb5QYubBazyuFG?=
 =?iso-8859-1?Q?66KlWU2RY5kPj3Gws0pDGNE5nCDKiRXa2MV3D52gMmqYTBYtQ1cqRMpJQU?=
 =?iso-8859-1?Q?ZwnYU6Nw0Ys21WIzYq937dkXxgjetL4Ai4rdd0FA209duPnhV727Xl/n7m?=
 =?iso-8859-1?Q?oEeTENyjT/FmTPwokBoyIid55qtZlUw5LhndthneQqcRnjwp5HxCkswEHH?=
 =?iso-8859-1?Q?X8GsJZYo93nN0HciA8ZOG+SnLXKZZ6Gw507h+WZcqm0/OLXDfpPcjDKW2U?=
 =?iso-8859-1?Q?v98CxcVZFIbD0dtp8k4Y8+p1WIMXDjGv1ZMVBYDEZ6S+vel5O6ru5sI1QI?=
 =?iso-8859-1?Q?EZGY+WICMrR3yRMDgNteeIYecmpP6mqAoHMWQwzl67HdxCh0q3bOafB/PM?=
 =?iso-8859-1?Q?HugTHP3ZorbfR+9iXaMcJUEgSfoJlGASC089nsIaCqFcJSvMbhLkG/nMjN?=
 =?iso-8859-1?Q?yGtAOgc7BbDHPjuN3vcmC94T+0P0iYhpmQ5gW+6cVVj/IIQ6NaDoyi7ds1?=
 =?iso-8859-1?Q?w4NdU2cC80RaHBK8z56XOLg0C+nM4j8wroRVzot/RB+/l+raMPo6iXfEnm?=
 =?iso-8859-1?Q?DUWW0Vx93IecjGeGhV4AcuOw7no4+WjA+Ne86ESapOpGjmWk3o2+mdmgem?=
 =?iso-8859-1?Q?54GIS7sT/zHphyD/7NF9QMLlX+PC5wWlLX7OvRB05ZTrLY9DbX/S+cK5rl?=
 =?iso-8859-1?Q?JQh0DkZYIJlFsZgIKl5qekEzuqiIIdB6BPnLnklGVK6lVg1wufMH+4pLEb?=
 =?iso-8859-1?Q?OPWidW2h2W90MprUDqxWEdRth6YRAzV9CGn0TIsgX3IdTt7Pxlok1zFJpF?=
 =?iso-8859-1?Q?Cr3Zx3VTogfyGFyHK48yLqCshfn7HnK0eDPXrsSX+S0/esK6sNsWuqXknb?=
 =?iso-8859-1?Q?wy4xKhkj++EIxvIvBXcbDWKz/mu+jJoQ8LmyM9Xu06tQe6jpj1VVUEmuxu?=
 =?iso-8859-1?Q?fGCqkupBzX9syYcAG9tUEVhDftOwkm9/JqzYILfG5O46fbpbwmL5uClxDG?=
 =?iso-8859-1?Q?XVG5LvNUcDmN9bkT3r5/6/0AXXWe5iokTNrojIon3FwtahzEIi2sRZVrUz?=
 =?iso-8859-1?Q?0/vHKS6h5UjAc+rvNbDaQbR+SduIyN6JI1ULGmM08hDAsqR+WtCphu/xLr?=
 =?iso-8859-1?Q?u3XvKhHU9zupdx3TbNXy7rl3PQxkeMfJsj7WzwiOqrHVYBwcS28PLjYtBe?=
 =?iso-8859-1?Q?mDAptqRvK82WbUqzn8MXj7kws3UeUSbyCXL7Jxgkz00Z2L4XsX11/TlCbW?=
 =?iso-8859-1?Q?8cHdZj3mNr2G1+1Uol0ewg9vS1/KmBbK+pkTt5olFFNuY6Y5C+9emMsP6s?=
 =?iso-8859-1?Q?sMxoN8kZbfVmm5JCWC0aoYOzlgzZRt2l/WR89zYhVmi2NC7bPp7bM=3D?=
x-forefront-antispam-report:
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:PH7PR19MB6979.namprd19.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230037)(366013)(376011)(1800799021)(38070700015);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-8859-1?Q?DV/MPwUfi5Td/Q7WCuzhKqZIzkhOMgnDah6yclSYBLpNmrmfK899cbYM+W?=
 =?iso-8859-1?Q?8u3LKvfl/TkKMxBHsKFBA16SJlVOpBifLcwLet1aIFv8yCxDCF7KYIbg2Y?=
 =?iso-8859-1?Q?QnOqncuUSMrYRoo9AIFtOjvagfV+IWofSXZ4hORhc+9ZgWMM82S21K8mzy?=
 =?iso-8859-1?Q?5z6zP3oDyqOJQzoR++ViBpUTuCKCnX00onuZRx1qRqKkJ1SVQ+b4bc4M0r?=
 =?iso-8859-1?Q?NpWKUPLQA0qc1fzeC+B09JkLLc7erDy+0WGHSVBdkUfc1ee8qmdU/8c0GO?=
 =?iso-8859-1?Q?JVrGLS7ltZEq7uqL2lQnv2ej+sn7STIMAiuZOVahx4VqraadDbvifFC2cy?=
 =?iso-8859-1?Q?YplsDmcvFtUwwg1ZR+CsRL2D12ONdsdw2+y5iyzQqHi4F4TGi3+8T8w4gq?=
 =?iso-8859-1?Q?okiZPGVXpSbjjIN+giO6YB7iJ1twefMFmNWI86eq9vEmhoWIgFLbJypaH5?=
 =?iso-8859-1?Q?g7+exEYdcAuSy0NiuZslppptWE1IdJzzIwxV4GQJKJPxZCOaLWiufbQNkl?=
 =?iso-8859-1?Q?kJsC7mZY6gqjYbv2vyJf7ynCnPdLXzZ/8QMu0/P3dvmr5K+nYzEuIwm5cM?=
 =?iso-8859-1?Q?P7TiP66/E8D3Z9t1g9BynYruJneFdNdaRq8I4nktHjo4Ov39nfmar1czlJ?=
 =?iso-8859-1?Q?l0yGSENvMzmjlxhXfGRUaIOdf/7hG0HSwiTnh+iH2IVG+DfA1iuFxJ3WcV?=
 =?iso-8859-1?Q?BVVR6tR7YZB+L6vr55h9kGNk8jDItgwHjbAsxHNCMkl44/pUa8OlT4f8Bo?=
 =?iso-8859-1?Q?6Cbdp3hFvZ8l6r1zYHocJxQ8wCl2F36aOEo5+H4HA0hjTiDjSgKTv4jJKf?=
 =?iso-8859-1?Q?n2AzpbeiybMzt7S5hejIUqlPwd3latcTngs+Cc3FKbVgf4nUgMfMAJ4E6P?=
 =?iso-8859-1?Q?D3Kc9UqQvV7eMCHc56dn13LDV6xp58g0u4m1y+JtVEc3sVOHpf+99EE5d2?=
 =?iso-8859-1?Q?wsdV89DUzGPFuIvatiyXKwzhbD27jzPPYbLJ8bP3Z55PN1f7nuUvTccVFe?=
 =?iso-8859-1?Q?1Xs5JBcuswuOiPFI+8HOgncvMJ34sxc4aIu0L20EMB0J/Ro4Gy5UqrVDZG?=
 =?iso-8859-1?Q?v3nIZg9HED7LX369Afgc0vdAkCTAitXb97FZ3V7IErY8QNATGy/jw/3Mhe?=
 =?iso-8859-1?Q?mOcJbsCVKpTg36Fe8db0SxZ7pw6jsfxy72yFlAs85x8qCbJpkveUdzcZtr?=
 =?iso-8859-1?Q?Zir5oAXfSyjsFI/Lm5FRhOGWDBh7deV+eeF+mw66ZoYILYAfqcirf5FXw9?=
 =?iso-8859-1?Q?XksEHejRuoOuIcGj8ZvbhXW09PRuVpHF51mJ2SuFCQaYvyCRUE1kyLV738?=
 =?iso-8859-1?Q?imXbou3d1en8Uj5pR2xHi0A4yiQ085PtgOsxtRtZBWAwywYsnJex1qirz1?=
 =?iso-8859-1?Q?PfPMpqETcLg5KX42XD3IH5fG2RQrMlVktsQEo5lBwYKB1reJwfXNSykgIf?=
 =?iso-8859-1?Q?y/i5l13a2gGx2w73KzUiiPG159UGl+0iuj6413Gr3tGBnSsFdqjBW/zM0h?=
 =?iso-8859-1?Q?b8+2pBLQELxdt2io2u+CfLjnOXFSPQxaJhCYqwJmzlDkUE/IMeJhpCOUcy?=
 =?iso-8859-1?Q?woePfjc8q745qd6ToMTKrVdupAw2jZjeM8g0MO834V3NBzswrY+UbQenqi?=
 =?iso-8859-1?Q?TL0sW2sWfuTbU=3D?=
Content-Type: multipart/alternative;
	boundary="_000_PH7PR19MB6979138226A0D5CB9120C1A0E6CD2PH7PR19MB6979namp_"
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0:
	9cQZP1p6M1SPbHUb7Q2rEb1PVOX9cKwJ+BLK3AMno3326Y85rNfrNM51hy0GeV6rtnyB54tD8g5f08Ti5Ri5yRxYzUiAtSOlS5+yIeFe9N3xhkPbyDA6Eo2Kjqml3VfKus/vp7qCmnD5C3SctkYHudrwb2TmbYqzK045OYiilwtdGes4wexqmk+nC+BPa/0Vyf7TyT8500dIyGQ9zfXqAsuR+7nUbAHEFawAdimAtmOWqlYJJP6oI5WhogDIRDnI6DgEEuLvLUCllnys07k8OrdtwmocnqXC7US9z01i8U95ahoQGv8GFfp5/ZeCzGZ9Ht6zdwUsXb1VCvU3eiLgH9zAYAjZrsZhPLoeNF/hP3IzuDaKaG/EYrchxx+di2LnETZ78/FStDT2dhWpiHSMCMNDnM0hkfk5sGK6uV/oOvzavqlL5n98cs6MqNgQcfIhrF3cjZDGHlFeZRx82T49fN8uVCUEVGPUlqsmNtIKCww84dnEKNvAy7zmWyi3QRKYaiyMZ4rTCz3WATQt5JKNd7efIZST8g4Hjat034dRW98e77VxAKlVsEamqnBVYEliDIicCZNxho/8NH733ycEHFj+AnCoxfJ/D4OQBW+c/jLHYONbYHu6N5Ne3bM6Wv7pe6CkGrNxn3LvaxGGSABlyQ==
X-OriginatorOrg: e1b.org
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: PH7PR19MB6979.namprd19.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 290cc582-1a6f-496c-9799-08dc8ed3d6ab
X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Jun 2024 13:46:07.0063
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 35eb8942-0df4-41e9-be40-9193ca17f25d
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: rEwbsvx1YLiqWpY9nxr6hTb3YrnBxpn1HFrOKsq3Idz94uo4aInBep+WoBdWptiN
X-MS-Exchange-Transport-CrossTenantHeadersStamped: PH0PR19MB7455
X-FEAS-SPF: spf-result=pass, ip=104.47.58.169, helo=nam11-bn8-obe.outbound.protection.outlook.com, mailFrom=ebenoit@e1b.org
X-FEAS-Client-IP: 104.47.58.169
X-FE-Last-Public-Client-IP: 104.47.58.169
X-FE-Policy-ID: 29:14:9:SYSTEM
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/PH7PR19MB6979138226A0D5CB9120C1A0E6CD2%40PH7PR19MB6979.namprd19.prod.outlook.com>
Precedence: bulk

--_000_PH7PR19MB6979138226A0D5CB9120C1A0E6CD2PH7PR19MB6979namp_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

What is a good data import configuration for only one server for WRITE-AHEA=
D LOG settings postgresql.conf where no one is connecting to the database a=
ccept me as a superuser.


Confidentiality Notice: This electronic message and any attachments may con=
tain confidential or privileged information, and is intended only for the i=
ndividual or entity identified above as the addressee. If you are not the a=
ddressee (or the employee or agent responsible to deliver it to the address=
ee), or if this message has been addressed to you in error, you are hereby =
notified that you may not copy, forward, disclose or use any part of this m=
essage or any attachments. Please notify the sender immediately by return e=
-mail or telephone and delete this message from your system.

--_000_PH7PR19MB6979138226A0D5CB9120C1A0E6CD2PH7PR19MB6979namp_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 11pt; color: rgb(0, 0, 0);">
What is a good data import configuration for only one server for WRITE-AHEA=
D LOG settings postgresql.conf where no one is connecting to the database a=
ccept me as a superuser.</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 11pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id=3D"Signature">
<div style=3D"text-align: left; background-color: white; margin: 0px; font-=
family: Calibri, Helvetica, sans-serif; font-size: 14pt; color: rgb(81, 167=
, 249);">
&nbsp;&nbsp;</div>
<div style=3D"background-color: white; margin: 0px;"></div>
</div>
Confidentiality Notice: This electronic message and any attachments may con=
tain confidential or privileged information, and is intended only for the i=
ndividual or entity identified above as the addressee. If you are not the a=
ddressee (or the employee or agent
 responsible to deliver it to the addressee), or if this message has been a=
ddressed to you in error, you are hereby notified that you may not copy, fo=
rward, disclose or use any part of this message or any attachments. Please =
notify the sender immediately by
 return e-mail or telephone and delete this message from your system.
</body>
</html>

--_000_PH7PR19MB6979138226A0D5CB9120C1A0E6CD2PH7PR19MB6979namp_--