Amazon’s Redshift uses which block size for its columnar storage?
A.
2KB
B.
8KB
C.
16KB
D.
32KB
E.
1024KB / 1MB
which block size for its columnar storage?
Amazon’s Redshift uses which block size for its columnar storage?
Leave a Reply
Amazon’s Redshift uses which block size for its columnar storage?
Amazon’s Redshift uses which block size for its columnar storage?
A.
2KB
B.
8KB
C.
16KB
D.
32KB
E.
1024KB / 1MB
The correct answer is E
https://snag.gy/8ymL2M.jpg
Typical database block sizes range from 2 KB to 32 KB. Amazon Redshift uses a block size of 1 MB, which is more efficient and further reduces the number of I/O requests needed to perform any database loading or other operations that are part of query execution.
http://docs.aws.amazon.com/redshift/latest/dg/c_columnar_storage_disk_mem_mgmnt.html