| From: | Ravi Krishna <srkrishna(at)outlook(dot)com> |
|---|---|
| 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:52:01 |
| Message-ID: | BYAPR01MB384810591FF49526B5FC486FB9D90@BYAPR01MB3848.prod.exchangelabs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
>
> 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:
>
I recollect reading something few years ago, but not able to place my finger on the issue. IIRC it was something to do with the inserting session creating a HOT bloat because vaccum could not do anything on that live session. I will try to search for that post. But the symptoms were similar to yours. Initially good performance and then getting slower and slower.
Q: Is it straight insert or you do select or updates also along with insert.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | soumik.bhattacharjee | 2018-11-20 18:10:05 | Oracle to Postgres-Licensed GUI tool |
| Previous Message | Stéphane KANSCHINE | 2018-11-20 16:41:03 | Re: inserts take longer and longer |