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
Attachment:
signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil