How to properly organize the database structure for user messages?

Question

MySQL

The following message storage structure comes to mind

type Message struct{
        Id int `gorm:"primary_key"`
        UserFromId int `sql:"not null"`
        UserToId int `sql:"not null"`
        Created string `sql:"DEFAULT:current_timestamp"`
        Message string
    }

What will happen when there are a lot of messages and how will this affect the speed?
Base - PostgreSQL (Maybe Redis)
Server - Golang
**Which framework are you using?**

Answer 1

Sharding and partitioning!
Well, if you do not have a couple of tens of millions of messages, from which dozens of samples must be taken every second, then there is nothing to worry about.
And don't forget the cache.