# What is the maximum number of documents an index can hold?

**URL:** https://discuss.elastic.co/t/what-is-the-maximum-number-of-documents-an-index-can-hold/229571
**Category:** Elasticsearch
**Created:** [April 24, 2020, 4:27am UTC](https://discuss.elastic.co/t/what-is-the-maximum-number-of-documents-an-index-can-hold/229571 "2020-04-24T04:27:30Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![neel1996](https://avatars.discourse-cdn.com/v4/letter/n/13edae/32.png) [@neel1996](https://discuss.elastic.co/u/neel1996)
#### Post date: [April 24, 2020, 4:27am UTC](https://discuss.elastic.co/t/what-is-the-maximum-number-of-documents-an-index-can-hold/229571/1 "2020-04-24T04:27:30Z")

</div>

Hi,

I am currently working on indexing searchable items from MS SQL to Elasticsearch. Currently there are over 20 million records which needs to be pushed to ES which constitutes to 20 millions documents in ES index.

The record count will keep increasing and we have a projection rate of 7 Million documents / year. The query is that, how many documents can a single index hold and is there a hard limit imposed by ES to limit document count.

Please clarify the query.

Thanks

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [April 24, 2020, 4:32am UTC](https://discuss.elastic.co/t/what-is-the-maximum-number-of-documents-an-index-can-hold/229571/2 "2020-04-24T04:32:16Z")

</div>

[Elasticsearch max number of documents for one index](https://discuss.elastic.co/t/elasticsearch-max-number-of-documents-for-one-index/26578/2) is still the limit on that 🙂

---

<div class="post-metadata">

### Author: ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [April 24, 2020, 5:12am UTC](https://discuss.elastic.co/t/what-is-the-maximum-number-of-documents-an-index-can-hold/229571/3 "2020-04-24T05:12:25Z")

</div>

There is a limit per shard (2billion) but this is not the limit for an index as an index can have multiple shards.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 22, 2020, 5:12am UTC](https://discuss.elastic.co/t/what-is-the-maximum-number-of-documents-an-index-can-hold/229571/4 "2020-05-22T05:12:31Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.