MIME-Version: 1.0
References: <CAM+6J95roDtn05fcobKJjWhG1YdJYwzoUFhjaj-dVOCw+9m6OQ@mail.gmail.com>
 <CH0PR03MB6100337240436C3FF72FDE37FE442@CH0PR03MB6100.namprd03.prod.outlook.com>
In-Reply-To: <CH0PR03MB6100337240436C3FF72FDE37FE442@CH0PR03MB6100.namprd03.prod.outlook.com>
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Tue, 15 Oct 2024 02:13:31 +0530
Message-ID: <CAJCZkoLbAjY5me5jdF-AzPanyfpY8na5RX2NUGvnaO4YNPExEw@mail.gmail.com>
Subject: Re: How to Copy/Load 1 billions rows into a Partition Tables Fast
To: "Wong, Kam Fook (TR Technology)" <kamfook.wong@thomsonreuters.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000748395062475e48a"
Archived-At: <https://www.postgresql.org/message-id/CAJCZkoLbAjY5me5jdF-AzPanyfpY8na5RX2NUGvnaO4YNPExEw%40mail.gmail.com>
Precedence: bulk

--000000000000748395062475e48a
Content-Type: text/plain; charset="UTF-8"

On Mon, 14 Oct, 2024, 23:29 Wong, Kam Fook (TR Technology), <
kamfook.wong@thomsonreuters.com> wrote:

> I am trying to copy a table (Postgres) that is close to 1 billion rows
> into a Partition table (Postgres) within the same DB.  What is the fastest
> way to copy the data?   This table has 37 columns where some of which are
> text data types.
>
> Thank you
> Kam Fook Wong
>
>
> This e-mail is for the sole use of the intended recipient and contains
> information that may be privileged and/or confidential. If you are not an
> intended recipient, please notify the sender by return e-mail and delete
> this e-mail and any attachments. Certain required legal entity disclosures
> can be accessed on our website:
> https://www.thomsonreuters.com/en/resources/disclosures.html
>

Hi Kam Fook Wong,

You can achieve it with pg_bulkload utility

Regards,
Durga Mahesh

>

--000000000000748395062475e48a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div><br><br><div class=3D"gmail_quote"><div dir=3D"ltr" =
class=3D"gmail_attr">On Mon, 14 Oct, 2024, 23:29 Wong, Kam Fook (TR Technol=
ogy), &lt;<a href=3D"mailto:kamfook.wong@thomsonreuters.com">kamfook.wong@t=
homsonreuters.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote"=
 style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">


<div lang=3D"EN-US" link=3D"blue" vlink=3D"purple" style=3D"word-wrap:break=
-word">
<div class=3D"m_4885261152791412020WordSection1">
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">I am trying to copy=
 a table (Postgres) that is close to 1 billion rows into a Partition table =
(Postgres) within the same DB.=C2=A0 What is the fastest way to copy the da=
ta?=C2=A0 =C2=A0This table has 37 columns where some
 of which are text data types.<br>
<br>
Thank you<br>
Kam Fook Wong<br>
<br>
<br>
<u></u><u></u></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
This e-mail is for the sole use of the intended recipient and contains info=
rmation that may be privileged and/or confidential. If you are not an inten=
ded recipient, please notify the sender by return e-mail and delete this e-=
mail and any attachments. Certain
 required legal entity disclosures can be accessed on our website: <a href=
=3D"https://www.thomsonreuters.com/en/resources/disclosures.html" target=3D=
"_blank" rel=3D"noreferrer">https://www.thomsonreuters.com/en/resources/dis=
closures.html</a></div></blockquote></div></div><div dir=3D"auto"><br></div=
><div dir=3D"auto">Hi Kam Fook Wong,</div><div dir=3D"auto"><br></div><div =
dir=3D"auto">You can achieve it with pg_bulkload utility</div><div dir=3D"a=
uto"><br></div><div dir=3D"auto">Regards,</div><div dir=3D"auto">Durga Mahe=
sh</div><div dir=3D"auto"><div class=3D"gmail_quote"><blockquote class=3D"g=
mail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-l=
eft:1ex"><div lang=3D"EN-US" link=3D"blue" vlink=3D"purple" style=3D"word-w=
rap:break-word">
</div>

</blockquote></div></div></div>

--000000000000748395062475e48a--