From: | Turbo Fredriksson <turbo(at)bayour(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Drop in performance for each INSERT/DELETE combo |
Date: | 2002-03-06 08:19:45 |
Message-ID: | 87it8ads66.fsf@papadoc.bayour.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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]
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SB SD | 2002-03-06 08:35:16 | Re: Postgresql backend to perform vacuum automatically |
Previous Message | Christopher Kings-Lynne | 2002-03-06 08:08:07 | Weird WAL numbering |