15.00 - Storage Limits - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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.