Re: big transaction slows down over time - but disk

Am Dienstag, den 31.10.2006, 21:58 -0800 schrieb Ben:
> I've got a long-running, update-heavy transaction that increasingly slows
> down the longer it runs. I would expect that behavior, if there was some
> temp file creation going on. But monitoring vmstat over the life of the
> transaction shows virtually zero disk activity. Instead, the system has
> its CPU pegged the whole time.
>
> So.... why the slowdown? Is it a MVCC thing? A side effect of calling
> stored proceedures a couple hundred thousand times in a single

Memory usage? Have you tried to checkpoint your transaction from time to
time?

Andreas

> transaction? Or am I just doing something wrong?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings