Re: Unlinked files in PGDATA/base following unclean shutdown

Поиск
Список
Период
Сортировка
От Jack Orenstein
Тема Re: Unlinked files in PGDATA/base following unclean shutdown
Дата
Msg-id 48A0650C.8000606@hds.com
обсуждение исходный текст
Ответ на Re: Unlinked files in PGDATA/base following unclean shutdown  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Unlinked files in PGDATA/base following unclean shutdown  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Tom Lane wrote:
> Jack Orenstein <jack.orenstein@hds.com> writes:

>> The question is how to check for consistency in the case of
>> large tables, which are split into multiple segments, (e.g. 123456.1,
>> 123456.2). I.e., how can I find out how many segments there should be?
>
> The kernel-defined EOF is the truth, the whole truth, and nothing but
> the truth.  There is no other authority.
>
> All segments before the last one should be exactly 1GB, but the last
> one can be anything up to that.  Consult the comments in md.c for
> more details.  (I think 7.4 may treat some corner cases differently
> from 8.3 anyway.)
>
>             regards, tom lane
>

Just to be clear, you mean 2**30 (1,073,741,824) bytes, not 10**9?

Jack

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

Предыдущее
От: Joao Ferreira gmail
Дата:
Сообщение: diagnostic, admin, maintenance tool
Следующее
От: Joao Ferreira gmail
Дата:
Сообщение: big database with very small dump !?