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
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
Hi, previously I selected categorized data for update then updated counts
or inserted a new record if it was a new category of data.
select all categories
update batches of categories
or insert batches [intermingled as they hit batch size]
Problem was the select was saturating the network (pullin
