Re: App very unresponsive while performing simple update

From: Jan de Visser <jdevisser(at)digitalfairway(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: App very unresponsive while performing simple update
Date: 2006-05-31 12:34:44
Message-ID: 200605310834.44935.jdevisser@digitalfairway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)digitalfairway(dot)com

                Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruno Wolff III 2006-05-31 15:11:41 Re: App very unresponsive while performing simple update
Previous Message Nis Jorgensen 2006-05-31 09:28:26 Re: Speedup hint needed, if available? :)