It seems pinot provides tier storage functionality. Does Pinot provide any metrics telling how old data to be stored with cold storage? Or we have to decide by ourself.

You configure