RE: Loading data from one table to another

Don't forget to look up the SQL state. There are some entries regarding it on stackoverflow

--
Holger Jakobs, Bergisch Gladbach
Tel. +49 178 9759012

Am 13. Oktober 2024 11:36:48 MESZ schrieb Jean-Paul POZZI <jp(dot)pozzi(at)izzop(dot)net>:
>Hello,
>
>
>
>It seems that the command is too lonbg to execute from pgadmin, try to execute the same Sql from a terminal ... or split your work with "from date1 to date2", you can split the work in 2,3 or more tasks and it will succed.
>
>
>
>Regards
>
>
>
>JP P
>
>
>
>
>
>
>
>De: "Sabyasachi Mukherjee" <mukherjee(dot)sabyasachi(at)outlook(dot)com>
>À: "undefined" <pgsql-admin(at)lists(dot)postgresql(dot)org>
>Envoyé: 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. The query performances are slow as 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 recorded 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 "AfterTriggerEvents".out of memory
>ERROR:  out of memory
>SQL state: 53200
>Detail: Failed on request of size 1048576 in memory context "AfterTriggerEvents".
>
>
>Thanks & regards
>
>
>Sabyasachi Mukherjee
>
>
>