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 1szs1b-008Rvm-Cf for pgsql-admin@arkaria.postgresql.org; Sun, 13 Oct 2024 06:24:19 +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 1szs1X-00GfHk-Vt for pgsql-admin@arkaria.postgresql.org; Sun, 13 Oct 2024 06:24:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1szs1X-00GfEK-Cw for pgsql-admin@lists.postgresql.org; Sun, 13 Oct 2024 06:24:15 +0000 Received: from mail-db8eur05olkn2103.outbound.protection.outlook.com ([40.92.89.103] helo=EUR05-DB8-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1szs1R-000dDW-2L for pgsql-admin@lists.postgresql.org; Sun, 13 Oct 2024 06:24:14 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=Mj/yj4OTsxIsFe5UpkElO+DJfAyQJYicaNtbbJuEIlw6hNTDnrbEbEbquQSCzLKu9n/u03WeJx0O8OG5iKtS3e0BZrvzEIBSlVbSlwfqTsgoTED9NH/WNrV44HzSf+yAPiWjtdtQUFXCXvRukrGigddB/aQqbUW6rpdxnB2LJ+JuHibppNyffavv3OyvNNGIoFoOhV2Sa8ux1IYeGuwLfTgW1bI4UGgrzkVWEJPoinWAn3s/XqGDZaQXmIQtcKSce45MIobCYKoLUKGnbPbeZGwKRtOVkkHdkvY1l0Z0YWmoy1JHt5aPbV85otERT9W1EbtzMdtKxL6Vhe9578AgOg== 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=Uio3q7hYSb71kct6shFYUp6Ceb4Y3h7FBcWZZbyuN6g=; b=RCpJ88AVtsZd5hjgMypRMIpNZS9x5dodE3Sqw+2hfovsPuIgzlO7x0ClBHE1kNWsbsrA9bJebISK9WaREIKl5/k1rC+U8DkmsALJWzSd1VcC0e0uVUjvvijRH69HNts3N80e3hn4iT+Bu/RPUWuFc93vUfFf3F/zzu7PEawB+yuIGxkxdI1eQSFytB1M/zUEBT7re/aQ0E55w8ER1hG1k1N1rAwMih4DRm+37f0lDe8u2x68eVJuWIQXWn2QTf9pUMDmOiCE8mj6uoVFIP8kW/EzgJKhQESFvQL4BYkjjAwkl6X93yL0RqNhFiKlJO+fOapo8e3ktJXeLuY3XXPvAw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=Uio3q7hYSb71kct6shFYUp6Ceb4Y3h7FBcWZZbyuN6g=; b=EW/b/qlw5B/Ob5aWe1SOAtpebpVRpsB5+4wc/vziQOPugQ3TlGqeXBzNWUu0qUUKSd8/0rWM3soqfj7f3wINPjwV3aUKcfErZYis5KzUEQjcdFmcjIwEIHRrh8xV/hzYjl8jZds5gkxBlt5Ako8a6TzRjyyv+EgCuLSIIgIk8h9aEtlklra8FHkzH7HxtCOAnEyc2uyNAysAeK+AyuZ+ywRbR4fhimjINHiuOgLyiC1e8tMaRis+SNNHleObwJDDx2iyrG0GJBltTLn5vsoKzK40zbryo++t8O0AOStKn0t3yVFnB6P3JoQZDWcpwlILJahqgo/6ADiXrxs+e+wAZg== Received: from DB7PR03MB3788.eurprd03.prod.outlook.com (2603:10a6:5:30::10) by DB3PR0302MB9205.eurprd03.prod.outlook.com (2603:10a6:10:429::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8048.25; Sun, 13 Oct 2024 06:24:05 +0000 Received: from DB7PR03MB3788.eurprd03.prod.outlook.com ([fe80::692b:59f4:c6a5:ef49]) by DB7PR03MB3788.eurprd03.prod.outlook.com ([fe80::692b:59f4:c6a5:ef49%2]) with mapi id 15.20.8048.020; Sun, 13 Oct 2024 06:24:05 +0000 From: Sabyasachi Mukherjee To: "pgsql-admin@lists.postgresql.org" Subject: Loading data from one table to another Thread-Topic: Loading data from one table to another Thread-Index: AQHbHTd44EbVmBQV6kGso1S6rljeYw== Date: Sun, 13 Oct 2024 06:24:04 +0000 Message-ID: Accept-Language: en-IN, en-US Content-Language: en-IN X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DB7PR03MB3788:EE_|DB3PR0302MB9205:EE_ x-ms-office365-filtering-correlation-id: a89d6897-6f21-444e-45c9-08dceb4fa30d x-microsoft-antispam: BCL:0;ARA:14566002|15030799003|8062599003|461199028|19110799003|8060799006|7092599003|15080799006|440099028|3412199025|102099032; x-microsoft-antispam-message-info: 9aCdoT3nSQVtfsvWUnvbjWAeUPRNQNhCxHJSKGJicQYOiUPye7/MujudmZ7bUon+wPJpvVsxlKzZJsCIAcfKAWK9PQu1wQfD1LBebS4UCoa1hp6oIuzDzQcT5WCmfw7UKC9ef3+TCNh4uFXUL7IDIY1rLL+NeRrnwpgKf+rrAK6lJeGikRCGyPtkvHKsUeeC/ohaRtimae9ES6ei7t45jzRlKEp6oxxIYA3viM0f1UEPRb/l4nz9dcB8vrt7dP2SQB59O0gZQMAcq4c/B2/u3bF0iOCM166/Ez5yJHOd9R1km1j4eAZ3kGBRusHAd1ks1wyrBJdGgJnXdW4dNGeoRmgw6LyJBoseTqOrPrmtTO7Lo9S25O8zxnDevgr54j9S0kjMU6oQMsTMra3rDmh4SWOZ8SycbpVdfU/5Tkeh/LL9xnpwTXIO0e/6Z5WvLb5QKotkexcs0r51dbmJyoIrFDIxeTWOnBAeN4iIQpkAo1XYmDfipRwga0z2BJ11+rcr/3OZbt3l2VCFf/yvgTxZ11v0u0OmF+pvQeiAcL7b+r/Uu62TAuhfIZru5rlRiF+iPjpZAxCeYqXMmg037fbAnVrtx9v5TYOvCe1seIyWOF6LCwG32REpegThhsJodUXU1ltZFXXvn5f2bMQPBpHG1GA5AfNjOsFPYUq+JKRs/yw6YRw02mkmgcY8ActJIHJsCyNCxIDcejtjKuNjEPhmXIekGL+ND2TR3AP45b1c8u8IvIvXFoxlQx+pxGBmUJcvEtkCt4MHa65BT/3AuqABnQ== x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?byLFmMsjlNnNMWIqOp4sPqdSiodjeqHJsgqTnMrCQQT+/jZM52BrKk/lln?= =?iso-8859-1?Q?VGx3EgPhi5uCwALlEyFcOLZTQNENPxyueofz8E/MAZ1P734q6diHHHY1UN?= =?iso-8859-1?Q?pC4a1rA4Rzxqxbd5QF/D9sM7UBj+YUVMy0OK6nd7RW77eVfWL/9ScKTmuO?= =?iso-8859-1?Q?zmAjAV2Bn2zM8MdgvUCofpe7IxVQ8fNOvcROjnnd7uU7wA4Z/40znDqBCV?= =?iso-8859-1?Q?/HDQTk8rOCbLDr+5DZ2CXM3iGIBCKHP699It0dAc7TDYUcnfadWLSLrsdV?= =?iso-8859-1?Q?iACPTw4e35/mIs3lM0O/bQXr/pkr+55y6WHb7dNUXallZHAaGndFBUZhaa?= =?iso-8859-1?Q?bP9hHrxBB6uNcDPSSmE5ej50A/A9xqnorpm44xqnMdtCuQOb0BlJBLfuqU?= =?iso-8859-1?Q?KfH4kcPSxbqK4FV/s6S0hWG4bQ70nNt8pGpMbrYiBNql1UkTu43wqX9tP2?= =?iso-8859-1?Q?OoULG/rwi2rHVdVOTmYIwoUIpjkmQOKGUl49Qo20CGkvmHaqXLdcbzlHym?= =?iso-8859-1?Q?UCZfE7vChwOoXRsAR+nw2zM6m6pU9MYrFoAp9eVJuRFUpaJNfTXyq7Rho0?= =?iso-8859-1?Q?upuLmiHwQ1JxN/H2PAw/3oYX7oBnsK8vxpqy2eeJliMt8Y3Gf4vlguSVjA?= =?iso-8859-1?Q?EJ5H67vuXWp7ZqdbYLMHn0A9dm9PpKTOPXrqfY2ao19IoVeD83uvezdc/D?= =?iso-8859-1?Q?1vf/oStvrxbPfa/B/2sQeF1bf4klQaNc9alrf8lfh2VS/o5yn2xw8j8uiY?= =?iso-8859-1?Q?q+kiRM3cRYeual5GDSjh3WpK2iHDUiG1o7M0hxUxbWFPisTsoR5CTS9aEd?= =?iso-8859-1?Q?L1dKdNJhfMBeAMZ8de/OWWRo5RMKP/m+hOs1DZTqz/VrfplX1PkABf1wd4?= =?iso-8859-1?Q?nq2iEGznV5gJk6s5pmVEpFP1oSC8MPValvzwEqYPsJeV/VCHsnAmAqaSia?= =?iso-8859-1?Q?D70xKB1W6ChiRtV/dKiSf/hyYzHAEkiutmK7zk2h9tQ72Ucqi5h8KQrQJA?= =?iso-8859-1?Q?zNf82Hq0Gr94dQ65bxBjbwrCnrBJjUnhj/6NorrC3fUR2o1X0opDEyTbGM?= =?iso-8859-1?Q?vefnMIFxcDKhjLqd9SSAvjPr08YYCv6Or/XyI/rZjXXt2zr/XMJUj49Gpx?= =?iso-8859-1?Q?2Byju7g8rvS7bxMi8BX6sMV3guFeQWQWF4Q4kbJ//x17m4pbsajD8cuKqq?= =?iso-8859-1?Q?yJmh1aZmYUyjgVCycHsc18pJN1Iv8qlKFMO6d+j1P74KuWa0mVNjeYM/E0?= =?iso-8859-1?Q?P1jHKymknBprb/va2LzR7bgjnnI/DgEjx35UN5zGjvelVrHnMKL5htAMPQ?= =?iso-8859-1?Q?H+ip?= Content-Type: multipart/alternative; boundary="_000_DB7PR03MB378887A0840FDAECF62410CD8C7B2DB7PR03MB3788eurp_" MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DB7PR03MB3788.eurprd03.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: a89d6897-6f21-444e-45c9-08dceb4fa30d X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Oct 2024 06:24:04.9992 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB3PR0302MB9205 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DB7PR03MB378887A0840FDAECF62410CD8C7B2DB7PR03MB3788eurp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear All, We have a Postgres DB with 99 GB of data. The query performances are slow a= s expected. I am trying to introduce monthly partitions for this table. To copy the data - the command that I am trying to execute is (Insert into = ...(Select * from )) using PGAdmin The DB is hosted in Windows server having 8 GB of RAM. Note - we do not have any surrogate key in this table. And the event time r= ecorded is also duplicated. The command fails every time. Can you please advise some strategy to get this done? Once the pgadmin lost connection. Another error that I have got is, ERROR: Failed on request of size 1048576 in memory context "AfterTriggerEv= ents".out of memory ERROR: out of memory SQL state: 53200 Detail: Failed on request of size 1048576 in memory context "AfterTriggerEv= ents". Thanks & regards Sabyasachi Mukherjee --_000_DB7PR03MB378887A0840FDAECF62410CD8C7B2DB7PR03MB3788eurp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear All,

We have a Postgres DB with 99 GB of data. The query performances are slow a= s expected. I am trying to introduce monthly partitions for this table.
To copy the data - the command that I am trying to execute is (Insert into = ...(Select * from )) using PGAdmin
The DB is hosted in Windows server having 8 GB of RAM.

Note - we do not have any surrogate key in this table. And the event time r= ecorded is also duplicated.

The command fails every time.
Can you please advise some strategy to get this done?

Once the pgadmin lost connection.
Another error that I have got is, 

ERROR:  Failed on request of size 1048576 in memory context "Afte= rTriggerEvents".out of memory
ERROR:  out of memory
SQL state: 53200
Detail: Failed on request of size 1048576 in memory context "AfterTrig= gerEvents".

Thanks & regards

Sabyasachi Mukherjee


--_000_DB7PR03MB378887A0840FDAECF62410CD8C7B2DB7PR03MB3788eurp_--