Re: Vacuum problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Peter Darley" <pdarley(at)kinesis-cem(dot)com>
Cc: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Vacuum problem
Date: 2002-08-13 01:50:40
Message-ID: 20764.1029203440@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Peter Darley" <pdarley(at)kinesis-cem(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-08-13 01:54:36 Re: question about upper limit on TEXT size
Previous Message Nigel J. Andrews 2002-08-13 01:19:26 Re: list tables