Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 832E59FB58F for ; Wed, 1 Nov 2006 14:54:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 47204-01-6 for ; Wed, 1 Nov 2006 14:53:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from heaven.kostyrka.org (h1634.serverkompetenz.net [81.169.154.44]) by postgresql.org (Postfix) with ESMTP id 9DA6C9FB591 for ; Wed, 1 Nov 2006 05:19:31 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by heaven.kostyrka.org (Postfix) with ESMTP id 45BC54FB8D; Wed, 1 Nov 2006 10:19:29 +0100 (CET) Received: from heaven.kostyrka.org ([127.0.0.1]) by localhost (heaven.kostyrka.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22929-01; Wed, 1 Nov 2006 10:19:29 +0100 (CET) Received: from [192.168.1.9] (85-124-82-106.dynamic.xdsl-line.inode.at [85.124.82.106]) by heaven.kostyrka.org (Postfix) with ESMTP id E63A74FB84; Wed, 1 Nov 2006 10:19:28 +0100 (CET) Subject: Re: big transaction slows down over time - but disk From: Andreas Kostyrka To: Ben Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-AZ1IBmH8e+oYvpp7T8u7" Date: Wed, 01 Nov 2006 10:21:01 +0100 Message-Id: <1162372861.18283.34.camel@andi-lap> Mime-Version: 1.0 X-Mailer: Evolution 2.6.3 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/9 X-Sequence-Number: 21779 --=-AZ1IBmH8e+oYvpp7T8u7 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Am Dienstag, den 31.10.2006, 21:58 -0800 schrieb Ben: > I've got a long-running, update-heavy transaction that increasingly slows= =20 > down the longer it runs. I would expect that behavior, if there was some=20 > temp file creation going on. But monitoring vmstat over the life of the=20 > transaction shows virtually zero disk activity. Instead, the system has=20 > its CPU pegged the whole time. >=20 > So.... why the slowdown? Is it a MVCC thing? A side effect of calling=20 > stored proceedures a couple hundred thousand times in a single=20 Memory usage? Have you tried to checkpoint your transaction from time to time? Andreas > transaction? Or am I just doing something wrong? >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings --=-AZ1IBmH8e+oYvpp7T8u7 Content-Type: application/pgp-signature; name=signature.asc Content-Description: Dies ist ein digital signierter Nachrichtenteil -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) iD8DBQBFSGb9HJdudm4KnO0RArQLAKDaij9dNfLSTSp+omNDSl7OYDey1gCgnE0w 6X38Z1bhpawuIUJGNpeVw48= =6d1r -----END PGP SIGNATURE----- --=-AZ1IBmH8e+oYvpp7T8u7--