From: | Juan Rodrigo Alejandro Burgos Mella <rodrigoburgosmella(at)gmail(dot)com> |
---|---|
To: | "Wong, Kam Fook (TR Technology)" <kamfook(dot)wong(at)thomsonreuters(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to Copy/Load 1 billions rows into a Partition Tables Fast |
Date: | 2024-10-15 04:27:57 |
Message-ID: | CAHbZ42wy7dNouZkmOOc8-pbZ++W+7Ez2bSPkcsM3QD9JHVtNyg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Wong
On one occasion I had to upload 600 million records, and the most viable
and safest option was to generate plans and upload them through a massively
parallelized process (because for each process we audited that everything
was correct)
Atte.
JRBM
El lun, 14 oct 2024 a las 14:59, Wong, Kam Fook (TR Technology) (<
kamfook(dot)wong(at)thomsonreuters(dot)com>) escribió:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | David Rowley | 2024-10-15 04:57:46 | Re: How to Copy/Load 1 billions rows into a Partition Tables Fast |
Previous Message | Muhammad Usman Khan | 2024-10-15 03:39:19 | Re: How to Copy/Load 1 billions rows into a Partition Tables Fast |