pg_bulkload slowing down

From: Sbob <sbob(at)quadratum-braccas(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: pg_bulkload slowing down
Date: 2025-07-28 13:07:35
Message-ID: 2846ad9c-e1d7-4780-b4e0-c2bceee64b64@quadratum-braccas.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Thoughts?

Thanks in advance for any help

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-07-28 13:17:32 Re: pg_bulkload slowing down
Previous Message Scott Ribe 2025-07-23 19:50:15 problem with MERGE command?