4 documented AWS Redshift cost inefficiencies, each with how to detect it and how to fix it.
AWS RedshiftCER-0363
A provisioned Amazon Redshift cluster bills every compute node for every hour it is available, whether or not any query runs. Clusters created for a proof of concept, a migration, a one-off analysis or a reporting workload that has since...
AWS RedshiftCER-0364
Development, test and staging Redshift provisioned clusters are typically used during working hours and by scheduled test runs, but they stay available around the clock because nobody set up a pause and resume schedule. Every night and...
AWS RedshiftCER-0365
Production Redshift provisioned clusters usually run continuously with a fixed node type and node count for long periods, which is exactly the usage pattern reserved nodes are designed for. When those nodes are billed at on-demand rates,...
AWS RedshiftCER-0366
Redshift Serverless bills compute in RPU-hours for the capacity in use while queries run, and the base capacity setting of a workgroup determines the capacity Redshift uses to serve queries. The default base capacity is 128 RPUs, and many...