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 1szvsW-008lBx-QX for pgsql-admin@arkaria.postgresql.org; Sun, 13 Oct 2024 10:31:12 +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 1szvsT-001o40-83 for pgsql-admin@arkaria.postgresql.org; Sun, 13 Oct 2024 10:31:09 +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 1szvsS-001o3q-BB for pgsql-admin@lists.postgresql.org; Sun, 13 Oct 2024 10:31:08 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1szvsO-000eq7-FH for pgsql-admin@lists.postgresql.org; Sun, 13 Oct 2024 10:31:07 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 8433D3808E3 for ; Sun, 13 Oct 2024 12:31:01 +0200 (CEST) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id z2tVmYkpODB1 for ; Sun, 13 Oct 2024 12:31:01 +0200 (CEST) Received: from [127.0.0.1] (dynamic-176-006-054-096.176.6.pool.telefonica.de [176.6.54.96]) by rs.plausibolo.de (Postfix) with ESMTPSA id 0C538380555 for ; Sun, 13 Oct 2024 12:31:01 +0200 (CEST) Date: Sun, 13 Oct 2024 12:31:00 +0200 From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Subject: RE: Loading data from one table to another User-Agent: K-9 Mail for Android In-Reply-To: <2131834790.929.1728812208526.JavaMail.zextras@jpp.fr> References: <2131834790.929.1728812208526.JavaMail.zextras@jpp.fr> Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=----ZUXEURZKJK1F61WD2U4YNW0EOGPLFK Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------ZUXEURZKJK1F61WD2U4YNW0EOGPLFK Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Don't forget to look up the SQL state=2E There are some entries regarding i= t on stackoverflow --=20 Holger Jakobs, Bergisch Gladbach=20 Tel=2E +49 178 9759012 Am 13=2E Oktober 2024 11:36:48 MESZ schrieb Jean-Paul POZZI : >Hello, > > > >It seems that the command is too lonbg to execute from pgadmin, try to ex= ecute the same Sql from a terminal =2E=2E=2E or split your work with "from = date1 to date2", you can split the work in 2,3 or more tasks and it will su= cced=2E > > > >Regards > > > >JP P > > > > > > > >De: "Sabyasachi Mukherjee" >=C3=80: "undefined" >Envoy=C3=A9: dimanche 13 octobre 2024 08:26 >Objet: Loading data from one table to another > > >Dear All, > > >We have a Postgres DB with 99 GB of data=2E The query performances are sl= ow as expected=2E I am trying to introduce monthly partitions for this tabl= e=2E >To copy the data - the command that I am trying to execute is (Insert int= o =2E=2E=2E(Select * from )) using PGAdmin >The DB is hosted in Windows server having 8 GB of RAM=2E > > >Note - we do not have any surrogate key in this table=2E And the event ti= me recorded is also duplicated=2E > > >The command fails every time=2E >Can you please advise some strategy to get this done? > > >Once the pgadmin lost connection=2E >Another error that I have got is,=C2=A0 > > >ERROR: =C2=A0Failed on request of size 1048576 in memory context "AfterTr= iggerEvents"=2Eout of memory >ERROR: =C2=A0out of memory >SQL state: 53200 >Detail: Failed on request of size 1048576 in memory context "AfterTrigger= Events"=2E > > >Thanks & regards > > >Sabyasachi Mukherjee > > > ------ZUXEURZKJK1F61WD2U4YNW0EOGPLFK Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Don'= t forget to look up the SQL state=2E There are some entries regarding it on= stackoverflow

--
Holger Jakobs, Bergisch Gladbach
Tel=2E +49 178 9759012
=


Am 13=2E Oktober= 2024 11:36:48 MESZ schrieb Jean-Paul POZZI <jp=2Epozzi@izzop=2Enet>:=

Hello,

 

It seems that the command is too lonbg to execute from pgadmin, try to = execute the same Sql from a terminal =2E=2E=2E or split your work with "fro= m date1 to date2", you can split the work in 2,3 or more tasks and it will = succed=2E

 

Regards

 

JP P

 



De: "Sabyasachi Mukherjee" <mukh= erjee=2Esabyasachi@outlook=2Ecom>
=C3=80: "undefine= d" <pgsql-admin@lists=2Epostgresql=2Eorg>
Envoy=C3=A9: dimanche 13 octobre 2024 08:26
Objet: Loading d= ata from one table to another

ERROR:  out of memory
SQL state: 53200