Re: Vacuum problem - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuum problem
Date
Msg-id 20764.1029203440@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum problem  ("Peter Darley" <pdarley@kinesis-cem.com>)
Responses Re: Vacuum problem  ("Peter Darley" <pdarley@kinesis-cem.com>)
List pgsql-general
"Peter Darley" <pdarley@kinesis-cem.com> writes:
> Sorry, I always forget to post the version.  I'm running 7.2.1 on Linux.

Drat ... I was hoping it was old ;-)

>     I deleted the records from pg_class and pg_type, and vacuum succeeded
> without any errors.

I'm glad you got out of the problem, but you shouldn't have got into it.
There's a bug there somewhere, and I need more data to try to look for
it.  Have you got any ideas about what might have triggered this
situation --- for example, were there any database crashes recently?
System crashes?  Odd behavior of any kind?

            regards, tom lane

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: list tables
Next
From: Tom Lane
Date:
Subject: Re: question about upper limit on TEXT size