Re: Errors when running vacuumdb...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Errors when running vacuumdb...
Дата
Msg-id 22736.1017730485@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Errors when running vacuumdb...  ("Dominic J. Eidson" <sauron@the-infinite.org>)
Ответы Re: Errors when running vacuumdb...  ("Dominic J. Eidson" <sauron@the-infinite.org>)
Список pgsql-general
"Dominic J. Eidson" <sauron@the-infinite.org> writes:
> when I run vacuumdb -a -v, I get:
> NOTICE:  Rel pg_attribute: Uninitialized page 1 - fixing
> ... more lines for page 2 through 50 ...
> NOTICE:  Rel pg_attribute: Uninitialized page 51 - fixing

> Any idea what causes this?

This is not good --- VACUUM is trying to recover from finding all-zero
pages in your table.  I would expect that the messages wouldn't recur
after you vacuum the table once; if they are repeatable then something
really strange is going on.  But the real question is why such pages
are in the file in the first place.

What PG version are you running?  Have you had any crashes or other
strange events lately?

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Medi Montaseri
Дата:
Сообщение: sync and cache
Следующее
От: Heiko Klein
Дата:
Сообщение: selecting random row