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] A Tale of 2 algorithms

2012-10-01 Thread Craig Ringer
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 bloating? Have you checked? Is it the table its self? One of its inde