awslabs / awslabs/amazon-redshift-utils
Table Size
- Dominant language
- Python
- Stars
- 2.8k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Description
Really confused by the table size calculation provided here.
According to docs, one takes the block size and multiplies by the columns, nodes, slices etc
I'm not seeing the same calculations in the SQL query, only a concatenated string of the components ?
Maybe I am misunderstanding your intent ?
https://aws.amazon.com/premiumsupport/knowledge-center/redshift-cluster-storage-space/
Minimum table size = block_size (1 MB) *
(number_of_user_columns + 3 system columns) * number_of_cluster_nodes *
number_of_table_segments
1MB * (3+3) * 6 *1 = 36 MB
Contributor guide
Research direction
Start by locating the SQL query that calculates table size and compare its concatenated components with the AWS Redshift table-size formula linked in the issue. Verify whether the query accounts for block size, user and system columns, cluster nodes, and table segments; done means the discrepancy is explained and the calculation or its documentation is corrected.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- aws, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100