Drop in performance for each INSERT/DELETE combo

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]

Responses

Browse pgsql-hackers by date

  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