Re: Unlinked files in PGDATA/base following unclean shutdown - Mailing list pgsql-general

From Jack Orenstein
Subject Re: Unlinked files in PGDATA/base following unclean shutdown
Date
Msg-id 48A0650C.8000606@hds.com
Whole thread Raw
In response to Re: Unlinked files in PGDATA/base following unclean shutdown  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Unlinked files in PGDATA/base following unclean shutdown
List 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 by date:

Previous
From: Joao Ferreira gmail
Date:
Subject: diagnostic, admin, maintenance tool
Next
From: Joao Ferreira gmail
Date:
Subject: big database with very small dump !?