Обсуждение: Vacuum goes into spin

Hi
    Running 6.5.3 on RedHat 6 (But kernel 2.2.13 or thereabouts)
Vacuum analyze table happily reports the stats on the table  and on one of
the 3 indexes.
    It then goes into a spin - i.e. 99+ % of the cpu & no disc activity.
Should I be concerned about the table structure or the solidity of vacuum ?

Brian Piatkus wrote:
>
> Hi
>         Running 6.5.3 on RedHat 6 (But kernel 2.2.13 or thereabouts)
> Vacuum analyze table happily reports the stats on the table  and on one of
> the 3 indexes.
>         It then goes into a spin - i.e. 99+ % of the cpu & no disc activity.
> Should I be concerned about the table structure or the solidity of vacuum ?

What does your server log say?