RE: inserts take longer and longer

we will try that and see if it helps.

-----Original Message-----
From: Stéphane KANSCHINE <stephane(at)hexack(dot)fr>
Sent: Tuesday, November 20, 2018 11:41 AM
To: David Modica <davidmo(at)imaginesoftware(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: inserts take longer and longer

Le mar. 20 nov., vers 15:55, David Modica exprimait :

> hi all.

Hi,

> I hope this is the correct way to get help from the list.
[...]
> we have a developer who is doing batch inserts 20 at a time and each
> subsequent batch is taking longer to the point where it is a critical
> problem. I recently changed the out of the box config to see if that
> would help but it hasn’t:
[...]
> any direction as to what to look at would be appreciated.

When you're doing bulk insert, it's a good practice to drop index and recreate it after.

Regards,
--
Stéphane KANSCHINE - https://www.hexack.fr./ - https://www.nuajik.io./
＠ stephane(at)hexack(dot)fr
 +33 6 64 31 72 52