Search Postgresql Archives

Re: Unlinked files in PGDATA/base following unclean shutdown

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Tom Lane wrote:
Jack Orenstein <jack.orenstein@xxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux