Re: page is not marked all-visible but visibility map bit is set in relation "pg_statistic"

From: Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
To: Gus Spier <gus(dot)spier(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: page is not marked all-visible but visibility map bit is set in relation "pg_statistic"
Date: 2024-07-11 20:38:56
Message-ID: c8fb146b-a2ae-4c65-ad0b-e21a65b1bcc4@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/11/24 19:21, Gus Spier wrote:
> AWS RDS Postgres Aurora version 14.4
>

I believe RDS and Aurora are two separate products, so I'm a bit
confused by this ...

> Error log shows: page is not marked all-visible but visibility map bit is
> set in relation "pg_statistic"
>
> To me, that sounds ominous. But, there does not appear to be any great
> performance hit. The applications are chugging along nicely. The end-users
> have not yet gathered at my door, waving torches and pitch-forks.
>
> What is the correct course of action in this case?
>

I'd say you need to report this to AWS support - we have no idea what
changes they made in Aurora, and AFAIK they made a lot of changes in
this area.

That is not to say we don't have any bugs in this area - see for example
the discussion in [1], but we are not in position to investigate issues
on a proprietary product.

regards

[1]
https://www.postgresql.org/message-id/CAH2-WznuNGSzF8v6OsgjaC5aYsb3cZ6HW6MLm30X0d65cmSH6A%40mail.gmail.com

--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Durgamahesh Manne 2024-07-12 06:45:04 Regarding tables detach concurrently with run_maintenance_proc()
Previous Message H 2024-07-11 20:28:35 Re: Running psql in a docker container