Redshift recommended free space percentage

0

I have a customer who is performing a migration of their on-premises DW to Redshift and is concerned about the amount of free space that the Redshift cluster should have at any time in order to maintain a good performance and don't run into issues when executing heavy queries or commands.

Do we have any guidance the maximum disk space percentage used within the cluster?

AWS
preguntada hace 6 años828 visualizaciones
2 Respuestas
0
Respuesta aceptada

Between 70% to 80% should be the maximum storage space used. This is for regular queries and day to day operations. You can configure a CloudWatch Alarm to monitor the disk usage of your cluster. If the customer is vacuuming a large table - they currently require approximately 3x the size of it in free space. As an example, a table that consumes 15% of cluster space, will require 45% free space in order to vacuum.

AWS
EXPERTO
respondido hace 6 años
0

correct, Maintain at least 20% free space or three times the size of the largest table https://d1.awsstatic.com/events/reinvent/2019/Deep_dive_and_best_practices_for_Amazon_Redshift_ANT418.pdf

AWS
respondido hace 8 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas