Re: More vacuum troubles
От
Dan Moschuk
Тема
Re: More vacuum troubles
Дата
Msg-id
20001110155331.A2902@spirit.jaded.net
Ответ на
Re: More vacuum troubles (Tom Lane)
Список
Дерево обсуждения
More vacuum troubles Dan Moschuk <dan@freebsd.org>
Re: More vacuum troubles Tom Lane <tgl@sss.pgh.pa.us>
Re: More vacuum troubles Dan Moschuk <dan@freebsd.org>
Re: More vacuum troubles Dan Moschuk <dan@freebsd.org>
Re: More vacuum troubles Dan Moschuk <dan@freebsd.org>
Re: More vacuum troubles Dan Moschuk <dan@freebsd.org>
Re: More vacuum troubles Tom Lane <tgl@sss.pgh.pa.us>
Re: More vacuum troubles Dan Moschuk <dan@freebsd.org>
| > 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 по дате отправления
