Re: vacuum pg_attribute causes high load

 

>>>>>>>>>>>>>>>>>>>>>>>>>
>> 1) Can you tell me if there is any other work around to vacuum the
>> pg_attribute system table ? Like doing it in parts so that it won't
> >cause a high load.

Chris Browne <cbbrowne@acm.org> wrote:
>No, you need to let the vacuum finish.
>If you stop it early, it'll just increase system load and accomplish _nothing_.

>>>>>>>>>>>>>>>>>>>>>>>>>

 

But while doing vacuum the load is getting so high that the system is almost freezing.

Does the performance of 'Vacuum' command depend on other system/ database parameters?  The 'vacuum pg_attribute" command never completes, its causing high load on the server. I had to wait for 15 mins and kill it.  Because the system load was touching 10, slowing down the system therefore not letting anyone access the server.

 

Can we vacuum the "pg_attribiute" in parts? So that 'vacuum' will complete faster and there won't be load issues.

Thanks Tom Lane and Chris Browne for your help so far.

 

-Krishna.