On 21/08/2011 11:07 PM, A J wrote:
So I assume there is no redundant information stored such as checksum
to validate the files against the stored checksums.
Nope, there are no checksums.
It's the storage subsystem's job to make sure it doesn't mangle data on
disk and reads the data as it was
: A J
Cc: PG Admin
Sent: Friday, August 19, 2011 2:40 AM
Subject: Re: [ADMIN] Question on Postgres Index internals
On 19/08/2011 5:46 AM, A J wrote:
How does Postgres detect corruption of index data files ?
If their structure doesn't make sense, they're corrupt. It doesn't acti
On 19/08/2011 5:46 AM, A J wrote:
How does Postgres detect corruption of index data files ?
If their structure doesn't make sense, they're corrupt. It doesn't
actively seek or detect corruption, because it shouldn't happen, and
cannot be reliably discovered if it has.
What is the exact mechani
How does Postgres detect corruption of index data files ? What is the exact
mechanism by which it knows that the index is corrupt ? Can it happen that part
of the index is corrupt but Postgres does not realize because those specific
rows are not accessed (but other rows from that table are acces
