How to Copy/Load 1 billions rows into a Partition Tables Fast

Поиск
Список
Период
Сортировка
От Wong, Kam Fook (TR Technology)
Тема How to Copy/Load 1 billions rows into a Partition Tables Fast
Дата
Msg-id CH0PR03MB6100337240436C3FF72FDE37FE442@CH0PR03MB6100.namprd03.prod.outlook.com
обсуждение исходный текст
Ответ на how to use trace_lock_oidmin config correctly  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Ответы Re: How to Copy/Load 1 billions rows into a Partition Tables Fast
Re: How to Copy/Load 1 billions rows into a Partition Tables Fast
Re: How to Copy/Load 1 billions rows into a Partition Tables Fast
Re: How to Copy/Load 1 billions rows into a Partition Tables Fast
Список pgsql-general
Дерево обсуждения

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

В списке pgsql-general по дате отправления: