Programming, Big Data, Redshift, AWS.
pivoting teases redshift leader node slowly. Last but not the least vacuuming after ingestion & purging takes lots of time because of the long primary key value distribution. catch 22 Redshift columnar storage takes 1MB per column per node - block size as a minimum unit. Columns potentially holding