Search Postgresql Archives

Re: Undetected corruption of table files

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

 



"Albe Laurenz" <all@xxxxxxxxxxxxxxxxx> writes:
> - Shouldn't there be an error, some kind of 'missing magic
>   number' or similar, when a table file consists of only
>   zeros?

The particular case of an all-zeroes page is specifically allowed,
and has to be because it's a valid transient state in various
scenarios.

> - Wouldn't it be desirable to have some means to verify the
>   integrity of a table file or a whole database?

SELECT * usually does reasonably well at that.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[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