On 12/9/20 12:07 AM, Huan Ruan wrote:
> HI Alvaro
>
> Unfortunately those records were written a while ago and we no longer keep
> their WAL logs. Thanks for your help anyway.
>
Can you estimate when roughly the records were written? E.g. by using a
rough estimate of WAL or XIDs generated per day, or something like that.
Maybe there was some I/O issue in that time period and a couple writes
got lost, or something like that.
Are there any other corrupted indexes on the table?
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company