Cockroach's SERIAL type is currently 64 bits. With the new added SEQUENCE functionality it is possible to implement SERIAL as a postgres compatible 32 bit type.

#18688

This might involve setting the current SERIAL type to a supported backwards compatibility type and introducing another type under the hood for new instances of the type. Caching functionality needs to be implemented for performance.