| From: | Stéphane KANSCHINE <stephane(at)hexack(dot)fr> |
|---|---|
| To: | David Modica <davidmo(at)imaginesoftware(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: inserts take longer and longer |
| Date: | 2018-11-20 16:41:03 |
| Message-ID: | 20181120164103.plefj3qzvgt6pd53@office.hexack.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravi Krishna | 2018-11-20 16:52:01 | Re: inserts take longer and longer |
| Previous Message | David Modica | 2018-11-20 15:55:34 | inserts take longer and longer |