DynamoDB Dynomite Indexes Limits
Creating Indexes Takes Time
Creating global secondary indexes can take a while, generally around 5-10 minutes. See: Wait Times. Additionally, you cannot create another index until this process is completed. You can create and delete one index at the same time, though. So two index operations, one for create and one for delete. We’ll show you how to add indexes in these docs: Adding Indexes
Indexes: Limits and Maxes
Max indexes for each type, see: create_table
- LSI: Max 5
- GSI: Max 20
- LSI must have table’s partition_key as one of its index keys. LSIs require a sort key. So, LSIs must be composite keys.
- LSI: There is no additional storage cost
- LSI: There is a 10 GB size limit per partition key value. After that, you won’t be able to add more items. See: create_table docs. If you think the LSI partition key and sort key can be greater than 10GB, it’s probably safer to use the more expensive GSI indexes.
- GSI: There is an additional storage cost. GSIs are essentially copies of the table. So it doubles the cost of storage. You can limit costs by projecting only specific attributes.