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 <pgsql-novice-owner+archive@lists.postgresql.org>)
	id 1qTmEi-00AdeN-Vw
	for pgsql-novice@arkaria.postgresql.org; Wed, 09 Aug 2023 16:40:41 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-novice-owner+archive@lists.postgresql.org>)
	id 1qTmEg-006wOt-UP
	for pgsql-novice@arkaria.postgresql.org; Wed, 09 Aug 2023 16:40:39 +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 <mahesh@digiledge.in>)
	id 1qTmEg-006wOl-H3
	for pgsql-novice@lists.postgresql.org; Wed, 09 Aug 2023 16:40:39 +0000
Received: from mail-maxind01on2124.outbound.protection.outlook.com
 ([40.107.222.124] helo=IND01-MAX-obe.outbound.protection.outlook.com)
	by magus.postgresql.org with esmtps  (TLS1.2) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <mahesh@digiledge.in>)
	id 1qTmEe-001W0s-MB
	for pgsql-novice@lists.postgresql.org; Wed, 09 Aug 2023 16:40:38 +0000
ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none;
 b=jvfnyA/KQoEOkGK/5BvwoIFKdy5Uos/xrSU+rsntcvhCr6aORYJXBJvAPqjO5CWTttK/cGxLiI46F3CiMCVw+++aLC2iqZC4lY++Qyzikwo7slcSxrWlzCvf3LKvRUF8sAkA0YuuijOcMMGdltoEYDARjm5+H6NaVsacbnvunYBlHQlpECZ/JbqUjAO/r1Kr6It03FaMNUf27sI8XfoZX7xxFuV60tVBha8kfWH62menwzwZxa9rDQs3ytoYxQVnNTZxvCgP5tISA5wA7MWyc00OzgxaSBQvJzuwW5mkMJVgsrcsqq0EzRIefayM5LVjpvXRhi19LaEPSwbfnRF/BA==
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=IX7eLOZSM1LhhxNxyNYnIewAhsWhuMaC9JsyrJ8j3iM=;
 b=PLNRI5W9ZMcwDomEDWCT9G0iEcn/OAohrY8PU5X2v2RIVepqgpzyFVYe63VkaMEGDpWTtsnuIdwdmNzRC/mB10RCeFSXvK4she0cJKnwweO71FcYxy7Jy75pEzhxSkNgVo4d+ygbLKgwq2VGT20LHl/hIFlN7ImsRJpZiZmgLwt6ge+0j30s1c6RKtO/2fje0agq9Cnxo9MI7GlDGHDQ0YPRTev8qh8LvoAh72YySb59zaEn68/Im55rF80lyQ6Zf5La/NjLy4e73gQJ9JYq4WRg9106cCU2hk83eR+lYKyOqBCXTYLX8n4YUjo6OIwY/Q32vI1T82SvLu2O8mzoaw==
ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass
 smtp.mailfrom=digiledge.in; dmarc=pass action=none header.from=digiledge.in;
 dkim=pass header.d=digiledge.in; arc=none
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=digiledge.onmicrosoft.com; s=selector1-digiledge-onmicrosoft-com;
 h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck;
 bh=IX7eLOZSM1LhhxNxyNYnIewAhsWhuMaC9JsyrJ8j3iM=;
 b=G/ebphPjO4smog85DrK6M+wP9udYRPEDjizjKyh/je4WXRBFE56CSQSXgs35uhtmnN/GmRxtjAV8B92q7UsehzXR6TRyk8vDB3r8Kx5+4hsonI3NN9VZN3R8Jju2ZG2YsXiCJWrReqay9636OrDfQicSv+r9Aat7P8PNMpclUyI=
Received: from MAXPR01MB2286.INDPRD01.PROD.OUTLOOK.COM (2603:1096:a00:59::19)
 by PNZPR01MB8329.INDPRD01.PROD.OUTLOOK.COM (2603:1096:c01:5e::9) with
 Microsoft SMTP Server (version=TLS1_2,
 cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6652.28; Wed, 9 Aug
 2023 16:40:31 +0000
Received: from MAXPR01MB2286.INDPRD01.PROD.OUTLOOK.COM
 ([fe80::b226:710c:7c88:459d]) by MAXPR01MB2286.INDPRD01.PROD.OUTLOOK.COM
 ([fe80::b226:710c:7c88:459d%4]) with mapi id 15.20.6652.026; Wed, 9 Aug 2023
 16:40:30 +0000
From: Mahesh Govind <mahesh@digiledge.in>
To: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Subject: Handling large number transactions
Thread-Topic: Handling large number transactions
Thread-Index: AQHZyt/0W+56AYhVNU2Euj1PDpSwUA==
Date: Wed, 9 Aug 2023 16:40:30 +0000
Message-ID: 
 <MAXPR01MB2286D2627D54B2D4EB5760E8A512A@MAXPR01MB2286.INDPRD01.PROD.OUTLOOK.COM>
Accept-Language: en-GB, en-US
Content-Language: en-GB
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
msip_labels: 
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=digiledge.in;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: MAXPR01MB2286:EE_|PNZPR01MB8329:EE_
x-ms-office365-filtering-correlation-id: 897e7272-55c3-44c2-f6b8-08db98f75832
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info: 
 JVwMTzaBX7Lo6v/LBqaKlLCz1jn2fXHO4J/UU1eRhyoa77NmSMM72IQE2NSx4nyUzRw/q+kL/3DAqsQD6+Pl0y7JQZJ4mGSJFw+Nxaa+YBGDTzrPYB7nwsmu5rVKWX85DDeH3SJnQ2LhSVw4qXZUT0ojKhzBMXKZJo72kHYvSittvj/Ge+JIF6EXs17FW9dM9EtxHglJeUt/ovy1OSaQcvYKg6OZ3cSaairwR/JOw1yCFwrro29n7yv5FUgLjSORz/bGH85C85GmUciR2IwecjJhrUVHwg1O169flxWeOi/584GwjuvdCgAy5HsG7HMqKs5uKAzWs/s+1gaRO5+3KsyiCepxwWFytJVPpv2EaYxLNWo9/bOq/8YWiDNBiMbTJnUUgegrf6dKtUd00b7LqTFxGW0Q1WuepHqLH16iP1LrPm29s2u6XJjAshY0v2rWSTKxCZqcdUETNxK630e0m94yHXjP4cu9N0iEKEbHNwiHWAzUXoJV9L0QC2tw2KRV3EFrd2+GWhloTH+xaWaNcDVCdSgQbHWHsmViEOn+jL6UcHStoo5EbLR24Ugt+unt9W0xEeYiRspR/UitXpKy/i9NapRvBYGB/+CldJx/5YgCCO+x1ft/EaJxtfOEEATV
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:MAXPR01MB2286.INDPRD01.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230028)(4636009)(346002)(136003)(39840400004)(376002)(396003)(366004)(451199021)(1800799006)(186006)(316002)(4744005)(71200400001)(41300700001)(2906002)(3480700007)(83380400001)(86362001)(19627405001)(52536014)(38070700005)(5660300002)(55016003)(8936002)(8676002)(6506007)(66476007)(33656002)(9686003)(7696005)(66946007)(122000001)(66556008)(64756008)(66446008)(76116006)(38100700002)(478600001)(6916009);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-8859-1?Q?o44jodbdoZbeDimzh03mymcvgdj5Veg9PHOhMg+ag2NWAwhIqNKfMLkFUl?=
 =?iso-8859-1?Q?hxH6rGEAF89axwoJtuV5aQs9A68//83+T2P95v0WGFUtJdHFErer9AWVMb?=
 =?iso-8859-1?Q?zyjf3jyUV2NFi4/+4d/FzLxw8Znm8u/DCD2sl5/ysucWzzd1T1vNDkGzq2?=
 =?iso-8859-1?Q?UIBPNigXwnqliSffW07Ea32zB+ZIpmd3Ba/zJYVs6aiQebgJCnV8pNHW5q?=
 =?iso-8859-1?Q?BS6DnU0SB0D8tS6o84Zvx6p68gqn/U+isz7jQFs8oOWBGPuMrfZwn+Bvk/?=
 =?iso-8859-1?Q?R8g+aYm8tfw9QSEEVVDdSoSfxV0jGoSA+hGd3zGLff7I+qXFlAM85lm/8a?=
 =?iso-8859-1?Q?SQ93caFVShyBTFou+fB6g2xrZuW8MVHHZdygAASTcZEINN7cYatUbWvu+S?=
 =?iso-8859-1?Q?DNmbEPVp9N3yFMzzCmqbeesjl26lgfwDOYUXxuICT77yJobJbumd3IIVHh?=
 =?iso-8859-1?Q?SQufh9wRfI2C5mJktzMBAGdxCX1LzKtK2GZUI4Pv0sfXNSOM18ffVDc1/p?=
 =?iso-8859-1?Q?USCpdDajzPNeND0JBaEYy1IB/Dr/mmM4h8AyGBG4i9Oh0tkJT0AnPH4NlB?=
 =?iso-8859-1?Q?NpSx+WpRDrquZkBj9d9iIaYfA9nr+vftJGDqOHYuvKYwaj7BV1hu9QG5jf?=
 =?iso-8859-1?Q?8vgkFkqw3tE7+1+gAa4iY1CCoUk82WCd2VSgNxB+xDlnYA6Ejl1wdHGelG?=
 =?iso-8859-1?Q?kkiTzjlIcksZEVA8SN+Jx3dIZBUejzco7hudY2oHYVtU9idHXujwigNiFK?=
 =?iso-8859-1?Q?00SmHvfv5lE8RAtT7NAw872XiqZqvcKVyz4GUIkg1Zdy/0ofogrFPt/U2L?=
 =?iso-8859-1?Q?aCraYGiISgRVgzUACrWXyCevCPrsdSVKPJF8q6Efzf9p2RlaVxdnnsyvPz?=
 =?iso-8859-1?Q?65LT5n0Nb+AN4MQ5rK359/yfZu6DeF7+yvsmwKb39txd3x4Bn7jbzMDzxB?=
 =?iso-8859-1?Q?vcK+42V4YpqRjQJh21DgaMeAOnKaNUWV8YwAK1zjVANuB3RDsiHPi7vOwH?=
 =?iso-8859-1?Q?VIdcBqFN4mf864kG0NbNXCbk5cVXiepgENtD9gDUWp4u06JKMCFaQuG+V0?=
 =?iso-8859-1?Q?VFj2qnRaoSGM41SnIwgXQQu+R1k1ualzajABucCQejFOgtmcRL14TpFUz7?=
 =?iso-8859-1?Q?5vBX0xfBdkAsJUiX2KFz4oH9l2Jtwy1s20qPn7eq71yQdY6/P6uhHQPqQE?=
 =?iso-8859-1?Q?ENHb2GWtFjOjoqWxMcnrNLeTDHfotoKoNNqEe1F+yQG3b8oqzDAP0POV/a?=
 =?iso-8859-1?Q?Wo8SrzOdLfCvhr4iQNSQP/RyP34lZZ1nEo9cjc4552W/jGpTov/HbA9VeC?=
 =?iso-8859-1?Q?d9yV/FtZwBtag+9jW70twzy/C87T7u4GHuZlxuQcnDE01TcmVIqxAxnV8J?=
 =?iso-8859-1?Q?0hpuyg+MTTXUUp3kVVl66qgLdWFyvHMpyxN/dXM0fXdNnEF8VGlcfmJk/c?=
 =?iso-8859-1?Q?WD+WvkHrpEgdPB6bSF/J+rGLuJWAk87B/S2+JA0NYonz/5duIyWfNBzNdc?=
 =?iso-8859-1?Q?eJ2ktX5LOu6xoIAXyAA06G1hCBIDyC+HUdcbgxbF4+9AucbqjmfZhzuGNv?=
 =?iso-8859-1?Q?rNwc7A52bJeQmOprKZjmeUtXYh1YCA2XxcWs2ADi9W37lVfF5GVfXovT64?=
 =?iso-8859-1?Q?7teyOq9YhKGugko2oP3K/vgG+qTTjMdzVpCJ6MNmbAG8S3rx+iV6EkaRib?=
 =?iso-8859-1?Q?Pre0QfJ/9aUU+bc9nVfXfBVLe+DPCpd1JPn3vjjO?=
Content-Type: multipart/alternative;
	boundary="_000_MAXPR01MB2286D2627D54B2D4EB5760E8A512AMAXPR01MB2286INDP_"
MIME-Version: 1.0
X-OriginatorOrg: digiledge.in
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: MAXPR01MB2286.INDPRD01.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 897e7272-55c3-44c2-f6b8-08db98f75832
X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Aug 2023 16:40:30.7098
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 29b3d7f3-477f-4f1c-8deb-fe3567e42e09
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 wMnJ0lS5ha9h4zYhBX5X6bZzXaJSrPoru6Ok+edBxh3tIQhM/IhMyCAT46LutNfhpHIoQZQaD4c7xTSMqf6CDA==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: PNZPR01MB8329
List-Id: <pgsql-novice.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-novice@lists.postgresql.org>
List-Owner: <mailto:pgsql-novice-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-novice>
Archived-At: 
 <https://www.postgresql.org/message-id/MAXPR01MB2286D2627D54B2D4EB5760E8A512A%40MAXPR01MB2286.INDPRD01.PROD.OUTLOOK.COM>
Precedence: bulk

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

Dear Experts ,


I have the following scenario.

On a given day I have to insert  3-4 million rows of data to a table .For p=
erformance reasons I would like to purge this data and move to another hist=
ory db.
The OLTP part I would like to do from one DB and the GUI queries I would li=
ke to do from a different DB replica .
Could you please help me with some pointers for the same .

with thanks and regards
mahesh


--_000_MAXPR01MB2286D2627D54B2D4EB5760E8A512AMAXPR01MB2286INDP_
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 style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
Dear Experts ,</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
<br>
</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
<br>
</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
I have the following scenario.</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
<br>
</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
On a given day I have to insert&nbsp; 3-4 million rows of data to a table .=
For performance reasons I would like to purge this data and move to another=
 history db.</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
The OLTP part I would like to do from one DB and the GUI queries I would li=
ke to do from a different DB replica .</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
Could you please help me with some pointers for the same .</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
<br>
</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
with thanks and regards</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
mahesh</div>
<div style=3D"font-family: Calibri, Arial, Helvetica, sans-serif; font-size=
: 12pt; color: rgb(0, 0, 0);" class=3D"elementToProof">
<br>
</div>
</body>
</html>

--_000_MAXPR01MB2286D2627D54B2D4EB5760E8A512AMAXPR01MB2286INDP_--