Best practices with Amazon Aurora PostgreSQL - Amazon Aurora

Best practices with Amazon Aurora PostgreSQL

Following, you can find several best practices for managing your Amazon Aurora PostgreSQL DB cluster. Be sure to also review basic maintenance tasks. For more information, see Managing Amazon Aurora PostgreSQL.

Troubleshooting storage issues

If the amount of memory required by a sort or index creation operation exceeds the amount of memory available, Aurora PostgreSQL writes the excess data to storage. When it writes the data, it uses the same storage space that it uses for storing error and message logs.

If your sorts or index creation functions exceed the memory available, you can run out of local storage. If you experience issues with Aurora PostgreSQL running out of storage space, you have a couple of options. You can either reconfigure your data sorts to use more memory, or reduce the data retention period for your PostgreSQL log files. For more information about changing the log retention period, see PostgreSQL database log files.

If your Aurora cluster is larger than 40 TB, don't use db.t2, db.t3, or db.t4g instance classes.