Re: pg_amcheck contrib application

[Mark Dilger]

> On Mar 16, 2021, at 9:07 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> 
> Mark Dilger <mark.dil...@enterprisedb.com> writes:
>> I think autovacuum simply triggers the bug, and is not the cause of the bug. 
>>  If I turn autovacuum off and instead do an ANALYZE in each test database 
>> rather than performing the corruptions, I get reports about problems in 
>> pg_statistic.  This is on my mac laptop.  This rules out the theory that 
>> autovacuum is propogating corruptions into pg_statistic, and also the theory 
>> that it is architecture dependent.
> 
> I wonder whether amcheck is confused by the declaration of those columns
> as "anyarray".

It uses attlen and attalign for the attribute, so that idea does make sense.  
It gets that via TupleDescAttr(RelationGetDescr(rel), attnum).

—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company