9. Limitations

Groonga has some limitations.

9.1. Limitations of table

A table has the following limitations.

  • The maximum one key size: 4KiB
  • The maximum total size of keys: 4GiB or 1TiB (by specifying KEY_LARGE flag to flags)
  • 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: 256GiB

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