Re: [PERFORM] A Tale of 2 algorithms

2012-10-04 Thread Colin Taylor
On Tue, Oct 2, 2012 at 5:54 PM, Craig Ringer wrote: > On 10/02/2012 05:24 AM, Colin Taylor wrote: > >> My thoughts are: surely 0-row updates dont cause this or have impact on >> the vacuum. I'm still doing the same updates after all why have things >> degenerated so badly? >> > > What exactly is

Re: [PERFORM] how to avoid deadlock on masive update with multiples delete

2012-10-04 Thread Jeff Janes
On Thu, Oct 4, 2012 at 7:01 AM, Anibal David Acosta wrote: > Hi, > > I have a table with about 10 millions of records, this table is update and > inserted very often during the day (approx. 200 per second) , in the night > the activity is a lot less, so in the first seconds of a day (00:00:01) a >

[PERFORM] how to avoid deadlock on masive update with multiples delete

2012-10-04 Thread Anibal David Acosta
Hi, I have a table with about 10 millions of records, this table is update and inserted very often during the day (approx. 200 per second) , in the night the activity is a lot less, so in the first seconds of a day (00:00:01) a batch process update some columns (used like counters) of this table