255 is the maximum array size representable with an unsigned byte. It is possible that old relational DBs could optimize arrays with sizes < 256.
I remember that the ancient Pascal dialect I used in college had max array sizes of 255 because they used a single byte for the size.