Re: How to Copy/Load 1 billions rows into a Partition Tables Fast - Mailing list pgsql-general

From Durgamahesh Manne
Subject Re: How to Copy/Load 1 billions rows into a Partition Tables Fast
Date
Msg-id CAJCZkoLbAjY5me5jdF-AzPanyfpY8na5RX2NUGvnaO4YNPExEw@mail.gmail.com
Whole thread Raw
In response to How to Copy/Load 1 billions rows into a Partition Tables Fast  ("Wong, Kam Fook (TR Technology)" <kamfook.wong@thomsonreuters.com>)
List pgsql-general


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

pgsql-general by date:

Previous
From: Zac Warham
Date:
Subject: Changing postgres User
Next
From: Adrian Klaver
Date:
Subject: Re: Changing postgres User