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 6142D9FA6A2 for ; Wed, 31 May 2006 14:35:03 -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 89438-07 for ; Wed, 31 May 2006 14:34:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.clickspace.com (router2.clickspace.com [65.110.166.227]) by postgresql.org (Postfix) with ESMTP id C3F7D9FA5E1 for ; Wed, 31 May 2006 14:34:49 -0300 (ADT) Received: from localhost ([127.0.0.1]) by mail.clickspace.com (using TLSv1/SSLv3 with cipher RC4-SHA (128 bits)); Wed, 31 May 2006 11:34:48 -0600 In-Reply-To: <200605310834.44935.jdevisser@digitalfairway.com> References: <961F6F02-4B00-494C-B071-6DF76A305C14@clickspace.com> <20060531062307.GG53487@pervasive.com> <09F270C9-7DF8-4574-AC70-CD7F9DA2C020@clickspace.com> <200605310834.44935.jdevisser@digitalfairway.com> Mime-Version: 1.0 (Apple Message framework v750) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <5C36D400-CDCE-41D1-AD5F-EBF03E5F9656@clickspace.com> Cc: pgsql-performance@postgresql.org Content-Transfer-Encoding: 7bit From: Brendan Duddridge Subject: Re: App very unresponsive while performing simple update Date: Wed, 31 May 2006 11:34:38 -0600 To: Jan de Visser X-Mailer: Apple Mail (2.750) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/569 X-Sequence-Number: 19356 Hi Jan, That sounds like a great idea! How would you control the update to occur only every 10,000 transactions? Is there a trigger setting for that somewhere? Thanks, ____________________________________________________________________ Brendan Duddridge | CTO | 403-277-5591 x24 | brendan@clickspace.com ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http://www.clickspace.com On May 31, 2006, at 6:34 AM, Jan de Visser wrote: > On Wednesday 31 May 2006 02:29, Brendan Duddridge wrote: >> We'll probably have to write a process to update the click_count from >> querying our product_click_history table. > > How about an insert trigger on product_click_history which updates > click_count > every say 10000 transactions or so? > > jan > > -- > -------------------------------------------------------------- > Jan de Visser jdevisser@digitalfairway.com > > Baruk Khazad! Khazad ai-menu! > -------------------------------------------------------------- > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >