Re: Index corruption

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> writes:
> It may or may not be the same issue, but for what it's worth, we've seen
>   the same sl_log_1 corruption on AIX 5.1 and 5.3

Hm, on what filesystem, and what PG version(s)?

I'm not completely satisfied by the its-a-kernel-bug theory, because if
it were then ISTM extending an index would be subject to the same risks
as extending a table; but I see no evidence of index page lossage in
Marc's dump.  OTOH the usage patterns are different, so maybe PG isn't
stressing the write-to-lseek path quite as hard for indexes.

			regards, tom lane