Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
SELECT AVG(CHAR_LENGTH(USER_ANNOTATIONS)) AS avg_chars,
       AVG(OCTET_LENGTH(USER_ANNOTATIONS)) AS avg_bytes
FROM NODE_REVISION
WHERE USER_ANNOTATIONS IS NOT NULL;

//Result

avg_chars = 686.5832
avg_bytes = 686.6047

For 26 million indexes documents it will be ~17GB data. The total data size, including annotations, is expected to remain within the OpenSearch Serverless limit of 1 TiB per index.

...