Re: More vacuum troubles - Mailing list pgsql-general

From Dan Moschuk
Subject Re: More vacuum troubles
Date
Msg-id 20001110155331.A2902@spirit.jaded.net
Whole thread Raw
In response to Re: More vacuum troubles  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
| > 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?

SELECT * FROM table does indeed succeed.

-Dan
--
Man is a rational animal who always loses his temper when he is called
upon to act in accordance with the dictates of reason.
                -- Oscar Wilde

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: More vacuum troubles
Next
From: "Martin A. Marques"
Date:
Subject: Postgres article