Re: [GENERAL] Vacuum goes into spin

From: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
To: Brian Piatkus <brian(at)brianp(dot)demon(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Vacuum goes into spin
Date: 2000-02-10 18:24:46
Message-ID: 38A3026E.8A6F247E@austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Harlander 2000-02-10 18:50:41 Dont understand Performance problem
Previous Message Ross J. Reedstrom 2000-02-10 17:35:10 Re: [GENERAL] view columm size.....