Drop in performance for each INSERT/DELETE combo
От | Turbo Fredriksson |
---|---|
Тема | Drop in performance for each INSERT/DELETE combo |
Дата | |
Msg-id | 87it8ads66.fsf@papadoc.bayour.com обсуждение исходный текст |
Ответы |
Re: Drop in performance for each INSERT/DELETE combo
Re: Drop in performance for each INSERT/DELETE combo |
Список | pgsql-hackers |
We're using a function to insert some information into the database. This information is later (within seconds) retrieved from a program, that does the actual processing of the information. It is then deleted from the database when we're done with it. We see a MAJOR performance loss the longer the time. It starts out from around 28 'data chunks' per second (inserts in a couple tables), and drops down to below 10/s... If doing 'VACUUM ANALYZE' every 20 minutes improves the performance, with the expected drop when the VACUUM is done, but in general the performance is steady... Investigation have shown that it's the actual DELETE that's slow, any idea how to find WHERE (and hopefully WHY :) this is so? -- attack Serbian radar PLO ammonium toluene Legion of Doom congress DES pits Ft. Bragg KGB Honduras kibo World Trade Center [See http://www.aclu.org/echelonwatch/index.html for more about this]
В списке pgsql-hackers по дате отправления: