9. Limitations

Groonga has some limitations.

9.1. Limitations of table

A table has the following limitations.

  • The maximum one key size: 4096Bytes
  • The maximum total size of keys: 4GBytes
  • The maximum number of records: 268,435,455 (more than 268 million)

Keep in mind that these limitations may vary depending on conditions.

9.2. Limitations of indexing

A full-text index has the following limitations.

  • The maximum number of distinct terms: 268,435,455 (more than 268 million)
  • The maximum index size: 256GBytes

Keep in mind that these limitations may vary depending on conditions.

9.3. Limitations of column

A column has the following limitation.

  • The maximum stored data size of a column: 256GiB