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
Last activity: Feb 5, 2025, 05:03 PM