Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 12B572E315E for ; Thu, 20 Dec 2007 07:14:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 82975-01 for ; Thu, 20 Dec 2007 07:14:39 -0400 (AST) Received: from hi-media.com (9.140-14-84.ripe.coltfrance.com [84.14.140.9]) by postgresql.org (Postfix) with ESMTP id 27B1E2E2FB1 for ; Thu, 20 Dec 2007 07:14:45 -0400 (AST) Received: from dim (gut75-1-81-57-27-121.fbx.proxad.net [81.57.27.121]) by hi-media.com (Postfix) with ESMTP id 8383C1880A9; Thu, 20 Dec 2007 12:13:35 +0100 (CET) From: Dimitri Fontaine Organization: Hi-Media To: pgsql-performance@postgresql.org Subject: Re: Minimizing dead tuples caused by update triggers Date: Thu, 20 Dec 2007 12:14:34 +0100 User-Agent: KMail/1.9.7 Cc: Decibel! , Tom Lane , Dan Harris References: <624895BA-B4D0-470B-80FC-4AE55C4FD85E@drivefaster.net> <1279.1198111185@sss.pgh.pa.us> In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart1982039.Gsg6JLAjRa"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200712201214.37113.dfontaine@hi-media.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/303 X-Sequence-Number: 28119 --nextPart1982039.Gsg6JLAjRa Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Le jeudi 20 d=C3=A9cembre 2007, Decibel! a =C3=A9crit=C2=A0: > A work-around others have used is to have the trigger just insert > into a 'staging' table and then periodically take the records from > that table and summarize them somewhere else. And you can even use the PgQ skytools implementation to easily have this ki= nd=20 of 'staging'-table with a producer and one or many subscribers. See those=20 references if you're interrested: http://kaiv.wordpress.com/2007/10/19/skytools-database-scripting-framework-= pgq/ http://skytools.projects.postgresql.org/doc/pgq-sql.html http://skytools.projects.postgresql.org/doc/pgq-admin.html http://skytools.projects.postgresql.org/doc/pgq-nodupes.html Hope this helps, regards, =2D-=20 dim --nextPart1982039.Gsg6JLAjRa Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBHak6dlBXRlnbh1bkRAppzAJ4pUwBTpAxvoJW35pmz3pcAxOrbqwCgh33I 1i5FtppUE8Oo3vy1obTR94c= =uJiQ -----END PGP SIGNATURE----- --nextPart1982039.Gsg6JLAjRa--