Try
Home   >   mailing lists

Re: pg_bulkload slowing down - Mailing list pgsql-admin

From Ron Johnson
Subject Re: pg_bulkload slowing down
Date
Msg-id CANzqJaBqSQUMP2g+P5SQEqfjicmnWbCvtzgRA-QvF0XjRFnB1A@mail.gmail.com
Whole thread Raw
In response to pg_bulkload slowing down  (Sbob <sbob@quadratum-braccas.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Sbob
Date:
Subject: pg_bulkload slowing down
Next
From: Álvaro Herrera
Date:
Subject: Re: pg_bulkload slowing down