we will try that and see if it helps. -----Original Message----- From: Stéphane KANSCHINE <stephane@xxxxxxxxx> Sent: Tuesday, November 20, 2018 11:41 AM To: David Modica <davidmo@xxxxxxxxxxxxxxxxxxx> Cc: pgsql-admin@xxxxxxxxxxxxxx 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@xxxxxxxxx +33 6 64 31 72 52
