From: David Modica <davidmo@imaginesoftware.com>
To: Stéphane KANSCHINE <stephane@hexack.fr>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: RE: inserts take longer and longer
Date: Wed, 21 Nov 2018 14:03:33 +0000
Message-ID: <2f1c29c8d9f54f5a9f996582c5f75c48@imaginesoftware.com> (raw)
In-Reply-To: <20181120164103.plefj3qzvgt6pd53@office.hexack.fr>
References: <9a645d6c8749483c90f5f109889ea8ce@imaginesoftware.com>
<20181120164103.plefj3qzvgt6pd53@office.hexack.fr>
we will try that and see if it helps.
-----Original Message-----
From: Stéphane KANSCHINE <stephane@hexack.fr>
Sent: Tuesday, November 20, 2018 11:41 AM
To: David Modica <davidmo@imaginesoftware.com>
Cc: pgsql-admin@postgresql.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@hexack.fr
+33 6 64 31 72 52
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: davidmo@imaginesoftware.com, stephane@hexack.fr
Subject: RE: inserts take longer and longer
In-Reply-To: <2f1c29c8d9f54f5a9f996582c5f75c48@imaginesoftware.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox