Re: inserts take longer and longer
От | Ravi Krishna |
---|---|
Тема | Re: inserts take longer and longer |
Дата | |
Msg-id | BYAPR01MB384810591FF49526B5FC486FB9D90@BYAPR01MB3848.prod.exchangelabs.com обсуждение исходный текст |
Ответ на | inserts take longer and longer (David Modica <davidmo@imaginesoftware.com>) |
Ответы |
RE: inserts take longer and longer
|
Список | 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 withthe inserting session creating a HOT bloat because vaccum could not do anything on that live session. I will try tosearch for that post. But the symptoms were similar to yours. Initially good performance and then getting slower andslower. Q: Is it straight insert or you do select or updates also along with insert.
В списке pgsql-admin по дате отправления: