Sample Header Ad - 728x90

Index maintenance on pg_catalog tables in AWS RDS

0 votes
1 answer
757 views
I have had some bad historical usage on my Aurora PostgreSQL instance. Namely, connections that create a lot of temporary objects and some very long running transactions (which limits autovacuum). Now I have some very, very bloat pg_catalog indices. For example: pg_attribute has only 34k records but *pg_attribute_relid_attnam_index and pg_attribute_relid_attnum_index are 630MB and 450MB!* In total I have gigabytes of (bloated) system indices on system tables. However, I cannot REINDEX or VACUUM FULL these tables due to permissions. Is this situation correctable in any way? Or is my RDS managed database permanently hosed and I need to migrate to a new one.
Asked by Paul Draper (800 rep)
Jul 7, 2021, 11:14 PM
Last activity: Feb 5, 2025, 05:03 PM