Re: [PERFORM] Performance degradation after successive UPDATE's

2005-12-08 Thread Assaf Yaari
rows) Time: 0.666 ms > -Original Message- > From: Bruno Wolff III [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 07, 2005 10:05 PM > To: Assaf Yaari > Cc: Jan Wieck; pgsql-performance@postgresql.org > Subject: Re: [PERFORM] Performance degradation after >

Re: [PERFORM] Performance degradation after successive UPDATE's

2005-12-07 Thread Assaf Yaari
ctions are open. Thanks, Assaf. > -Original Message- > From: Jan Wieck [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 06, 2005 2:35 PM > To: Assaf Yaari > Cc: Bruno Wolff III; pgsql-performance@postgresql.org > Subject: Re: [PERFORM] Performance degradation after >

Re: [PERFORM] Performance degradation after successive UPDATE's

2005-12-06 Thread Assaf Yaari
Bruno Wolff III [mailto:[EMAIL PROTECTED] > Sent: Monday, December 05, 2005 10:36 PM > To: Assaf Yaari > Cc: pgsql-performance@postgresql.org > Subject: Re: Performance degradation after successive UPDATE's > > On Mon, Dec 05, 2005 at 19:05:01 +0200, > Assaf Yaari <[E

[PERFORM] Performance degradation after successive UPDATE's

2005-12-05 Thread Assaf Yaari
Hi,   I'm using PostgreSQL 8.0.3 on Linux RedHat WS 3.0.   My application updates counters in DB. I left a test over the night that increased counter of specific record. After night running (several hundreds of thousands updates), I found out that the time spent on UPDATE increased to be mor