(Full disclosure: I am the Product Manager for Amazon Aurora with PostgreSQL compatibility). We set the default shared_buffers to 75% of total memory because, as you state, there is no file system cache with Aurora Storage. If you need to support large index creates, or queries that do sorts on large tables, etc, then you should consider increasing the work_mem parameter. However, you may need to concurrently decrease shared_buffers to avoid running out of memory. We are working on recommendations / best practices for setting Amazon Aurora PostgreSQL memory-related parameters based on your workload, and will publish those soon.

Explication du fonctionnement du stockage en mode block

Vraiment intéressant sur le tuning des instances EC2

Voir les commentaires pour les retours d'expérience

pas mal de retours d’expérience et de limitations sur RDS/aurora

Retour d'expérience

Descriptif des différents types d'instances