Storage Limits - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

Storage Limits

 

Parameter

Value

Total data capacity

~ 12 TB/AMP

Minimum data block size with small cylinders

~9KB

18  512‑byte sectors

Default data block size with small cylinders

~127KB

254  512‑byte sectors

Maximum data block size with small cylinders

~256KB

512  512‑byte sectors

Minimum data block size with large cylinders

~21KB

42  512‑byte sectors

Default data block size with large cylinders

~127KB

254  512‑byte sectors

Maximum data block size for a large cylinder system that does not use 4KB alignment

1,023.5KB

2,047 sectors

Maximum data block size for a large cylinder system that uses 4KB alignment

1,024KB

2,048 sectors

Maximum number of data blocks that can be merged per data block merge

8

Maximum merge block ratio

100% of the maximum multirow block size for a table.