How large a table can be kept in Jira using the grid

The add-on use native database tables, so the limits are imposed by the underlying database configuration. In most cases it's almost limitless (given available disk space).