Re: Unlinked files in PGDATA/base following unclean shutdown

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