Postgres Pro
Downloads
Home   >   mailing lists

Re: App very unresponsive while performing simple update - Mailing list pgsql-performance

From Jan de Visser
Subject Re: App very unresponsive while performing simple update
Date
Msg-id 200605310834.44935.jdevisser@digitalfairway.com
Whole thread Raw
In response to Re: App very unresponsive while performing simple update  (Brendan Duddridge <brendan@clickspace.com>)
Responses Re: App very unresponsive while performing simple update
List pgsql-performance
Tree view 
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!
--------------------------------------------------------------

pgsql-performance by date:

Previous
From: Nis Jorgensen
Date:
Subject: Re: Speedup hint needed, if available? :)
Next
From: Bruno Wolff III
Date:
Subject: Re: App very unresponsive while performing simple update