Re: page is uninitialized?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: page is uninitialized?
Дата
Msg-id 26215.1145458931@sss.pgh.pa.us
обсуждение исходный текст
Ответ на page is uninitialized?  (Brendan Duddridge <brendan@clickspace.com>)
Ответы Re: page is uninitialized?  (Brendan Duddridge <brendan@clickspace.com>)
Список pgsql-general
Brendan Duddridge <brendan@clickspace.com> writes:
> I was doing a vacuum analyze verbose on my database today and I
> noticed the following message printed out:

> WARNING:  relation "category_product" page 128979 is uninitialized
> --- fixing
> WARNING:  relation "category_product" page 128980 is uninitialized
> --- fixing
> ...

There are some situations in which this is expected, which is why
VACUUM deals with it, but none of them are very good: they involve
backends adding a page to a table and then failing before they can
write a WAL record about initializing the page.  Have you had any
crashes recently?

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: page is uninitialized?
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Categories and Sub Categories (Nested)