public inbox for [email protected]
help / color / mirror / Atom feedFrom: Holger Jakobs <[email protected]>
To: [email protected]
Subject: RE: Loading data from one table to another
Date: Sun, 13 Oct 2024 12:31:00 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <DB7PR03MB378887A0840FDAECF62410CD8C7B2@DB7PR03MB3788.eurprd03.prod.outlook.com>
<[email protected]>
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 <[email protected]>:
>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" <[email protected]>
>À: "undefined" <[email protected]>
>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
>
>
>
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: RE: Loading data from one table to another
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox