Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Vacuum goes into spin - Mailing list pgsql-general

From Ed Loehr
Subject Re: [GENERAL] Vacuum goes into spin
Date
Msg-id 38A3026E.8A6F247E@austin.rr.com
Whole thread Raw
In response to Vacuum goes into spin  (Brian Piatkus <brian@brianp.demon.co.uk>)
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: [GENERAL] view columm size.....
Next
From: Magnus Harlander
Date:
Subject: Dont understand Performance problem