Alternatives to VACUUM FULL in AWS Aurora and RDS
In addition to the post “Alternatives to VACUUM FULL in Postgres”, here is an overview of what is possible within Aurora/RDS AWS.
Available in Aurora/RDS AWS
VACUUM FULL | ✅ |
AUTOVACUUM | ✅ |
manual copy | ✅ |
pg_repack | ✅ |
pg_squeeze | ❌ |
Additional Information
pg_repack
The pg_repack extension is available on AWS. All available versions can be found at https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html.
pg_repack can only be run from the console. However, Aurora and RDS are managed services without access to the server. This means that execution and installation on the server is not possible.
Therefore an EC2 instance is needed as a client machine, where pg_repack is installed and a connection to the RDS/Aurora instance is established.
More details on how to set this up can be found in the following blog: https://aws.amazon.com/de/blogs/database/remove-bloat-from-amazon-aurora-and-rds-for-postgresql-with-pg_repack/
pg_squeeze
Unfortunately, the pg_squeeze extension is currently not supported by Amazon Aurora/RDS.
It is not listed in Amazons available RDS extensions: https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html
There are currently no official plans to make this available in the near future.
To be informed when it becomes available, I recommend watching the following links:
AWS RDS Blog: https://aws.amazon.com/blogs/aws/category/amazon-rds/
AWS RDS forum: https://forums.aws.amazon.com/forum.jspa?forumID=60
What’s new Blog: https://aws.amazon.com/new/
Interested in more information about VACUUM? Here are all the posts: |