Postgres Pro
Downloads
Home   >   mailing lists

Re: More vacuum troubles - Mailing list pgsql-general

From Tom Lane
Subject Re: More vacuum troubles
Date
Msg-id 21416.973888569@sss.pgh.pa.us
Whole thread Raw
In response to Re: More vacuum troubles  (Dan Moschuk <dan@freebsd.org>)
Responses Re: More vacuum troubles  (Dan Moschuk <dan@freebsd.org>)
List pgsql-general
Tree view 
Dan Moschuk <dan@freebsd.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

pgsql-general by date:

Previous
From: Gunnar R|nning
Date:
Subject: Re: Full text searching?
Next
From: Dan Moschuk
Date:
Subject: Re: More vacuum troubles