Re: pg_bulkload slowing down

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: pg_bulkload slowing down
Дата
Msg-id CANzqJaBqSQUMP2g+P5SQEqfjicmnWbCvtzgRA-QvF0XjRFnB1A@mail.gmail.com
обсуждение исходный текст
Ответ на pg_bulkload slowing down  (Sbob <sbob@quadratum-braccas.com>)
Список pgsql-admin
Дерево обсуждения
On Mon, Jul 28, 2025 at 9:07 AM Sbob <sbob@quadratum-braccas.com> wrote:
All;


We are loading a series of files into a single table, each file has
approx 500million rows, the first file took ~ 1.25 hours, now on file
number 8 it has been running for more than 10 hours, there is only a PK
index on the table.

Triggers?  Foreign Keys?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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