Re: [PERFORM] very long updates very small tables

2011-04-04 Thread Lars Feistner
On 03/30/2011 06:54 PM, Kevin Grittner wrote: Lars Feistner wrote: On 03/29/2011 09:28 PM, Kevin Grittner wrote: Lars Feistner wrote: The log tells me that certain update statements take sometimes about 3-10 minutes. But we are talking about updates on tables with 1000 to 1 rows and

Re: [PERFORM] very long updates very small tables

2011-03-30 Thread Lars Feistner
Hello Kevin, On 03/29/2011 09:28 PM, Kevin Grittner wrote: Lars Feistner wrote: The log tells me that certain update statements take sometimes about 3-10 minutes. But we are talking about updates on tables with 1000 to 1 rows and updates that are supposed to update 1 row. The top

[PERFORM] very long updates very small tables

2011-03-29 Thread Lars Feistner
ecute : UPDATE extjs_recentlist SET visible=$1 WHERE recentlist_id=$2 DETAIL: parameters: $1 = 't', $2 = '31' LOG: duration: 124654.000 ms execute : UPDATE extjs_recentlist SET visible=$1 WHERE recentlist_id=$2 DETAIL: parameters: $1 = 't', $2 = '1362