X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DC8069FA5F0 for ; Wed, 31 May 2006 09:34:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 16760-07 for ; Wed, 31 May 2006 09:34:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.digitalfairway.ca (ns.digitalfairway.ca [207.164.133.170]) by postgresql.org (Postfix) with ESMTP id C9C2C9FA5DD for ; Wed, 31 May 2006 09:34:47 -0300 (ADT) Received: from toronto.toronto.digitalfairway.ca (unknown [192.168.100.10]) by mail.digitalfairway.ca (Postfix) with ESMTP id B508AA0553 for ; Wed, 31 May 2006 08:34:45 -0400 (EDT) Received: from localhost (localhost.localdomain [127.0.0.1]) by toronto.toronto.digitalfairway.ca (Postfix) with ESMTP id 72A2E164603 for ; Wed, 31 May 2006 08:34:45 -0400 (EDT) Received: from toronto.toronto.digitalfairway.ca ([127.0.0.1]) by localhost (toronto.toronto.digitalfairway.ca [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26089-08 for ; Wed, 31 May 2006 08:34:45 -0400 (EDT) Received: from [192.168.100.50] (unknown [192.168.100.50]) (using SSLv3 with cipher EXP1024-RC4-SHA (56/128 bits)) (No client certificate requested) by toronto.toronto.digitalfairway.ca (Postfix) with ESMTP id DF9EF164607 for ; Wed, 31 May 2006 08:34:44 -0400 (EDT) From: Jan de Visser To: pgsql-performance@postgresql.org Subject: Re: App very unresponsive while performing simple update Date: Wed, 31 May 2006 08:34:44 -0400 User-Agent: KMail/1.9.1 References: <961F6F02-4B00-494C-B071-6DF76A305C14@clickspace.com> <20060531062307.GG53487@pervasive.com> <09F270C9-7DF8-4574-AC70-CD7F9DA2C020@clickspace.com> In-Reply-To: <09F270C9-7DF8-4574-AC70-CD7F9DA2C020@clickspace.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200605310834.44935.jdevisser@digitalfairway.com> X-Virus-Scanned: amavisd-new at digitalfairway.ca X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/566 X-Sequence-Number: 19353 On Wednesday 31 May 2006 02:29, Brendan Duddridge wrote: > We'll probably have to write a process to update the click_count from =A0 > querying our product_click_history table. How about an insert trigger on product_click_history which updates click_co= unt=20 every say 10000 transactions or so? jan =2D-=20 =2D------------------------------------------------------------- Jan de Visser =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 jdevisser@digitalfair= way.com =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Baruk Khazad! Khazad ai-menu! =2D-------------------------------------------------------------