What relational databases have you worked with? Have you dealt with sharding and partitioning tasks?

I have worked with several relational databases, including PostgreSQL, MySQL, and Microsoft SQL Server. In projects, I had to solve tasks related to sharding and partitioning data.

Partitioning is the division of tables into logical parts within a single database to improve performance and data management. For example, you can partition a table by date to make queries on recent data faster.

Sharding is the horizontal division of data across multiple servers or database instances. This helps scale the system as data volume and load increase.

In one project, I participated in implementing partitioning of tables in PostgreSQL by date ranges, which significantly sped up queries on historical data. I also have experience setting up sharding at the application level, where data was distributed across multiple MySQL servers by user key to balance load and ensure fault tolerance.