The below query returns 75GB on redshift while on mysql the equivalent query returns 40GB.
select size from svv_table_info where "table"='table_name'
I always assumed redshift saves on disk space by sorting and distributing data in blocks and not having indexes.
What may be the reason for the differences that i missed? I checked that :
- there are no missing rows or columns on Mysql
- Redshift table is vacuumed regularly