Re: More vacuum troubles

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dan Moschuk <dan(at)freebsd(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: More vacuum troubles
Date: 2000-11-10 20:36:09
Message-ID: 21416.973888569@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dan Moschuk <dan(at)freebsd(dot)org> writes:
> vacuum some_table (without the analyze) completes quite happily.

It sounds like you've got some corrupted data in that table. Plain
vacuum doesn't really pay any attention to what's in the rows it's
shuffling around, but vacuum analyze does...

Does a SELECT * FROM that table succeed?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Moschuk 2000-11-10 20:53:31 Re: More vacuum troubles
Previous Message Gunnar R|nning 2000-11-10 20:08:24 Re: Full text searching?