1

I am using aurora-postgresql version 9.6.8. and I have one main instance , one writer and one reader replica. I am looking for below information: How I can check on a particular instance when autovacuum was executed when I am trying to use "pg_stat_user_tables"? This show lot of dead tuples. But when we see max last autovacuum executed date its one month back. Seems like autovacuum not executed from last one month on any of the table. In my environment we have huge insert update and delete every day. Thank you in advance for any suggestion!!!

Below is my auto vacuum configuration:

name                            setting
autovacuum_analyze_scale_factor 0.05
autovacuum_analyze_threshold    50
autovacuum_freeze_max_age       200000000
autovacuum_max_workers          4
autovacuum_naptime              5
autovacuum_vacuum_cost_delay    5
autovacuum_vacuum_cost_limit    -1
autovacuum_vacuum_scale_factor  0.1
autovacuum_vacuum_threshold     50
maintenance_work_mem            4122624
vacuum_cost_limit               200
vacuum_freeze_min_age           50000000

1 Answer 1

0

Did you contact AWS support? The version 9.6.8 aurora-postgresql has a metadata corruption bug that could lead to this symptom that you have described. You probably need to upgrade.

I have recently encountered this problem twice in production, and AWS support was helpful in each event.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.