This repository has been archived by the owner on Dec 17, 2024. It is now read-only.
Replies: 1 comment
-
Hello. Thanks a lot for your hint. Fixed just today in #760 :-) |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I was analyzing an issue regarding table freezing, the database studied is Gitlab, the pgwatch health check dashboard indicates 2 billion for this metric, investigating how close the database is from wrapround, no evidence emerged for this, another observation was using the pgwatch's query metric.sql it indicates that tables with the highest freezing value are of partitioned type. Therefore, according to the Postgresql documentation (https://www.postgresql.org/docs/16/sql-analyze.html) it indicates that autovacuum daemon does not process partitioned tables. So my question is whether the query should consider partitioned tables, in the condition relkind in ('r','p').
Beta Was this translation helpful? Give feedback.
All reactions