Does PostgreSQL support data sharding?

PostgreSQL does not support automatic sharding (data partitioning across shards) as a built-in feature out of the box. However, starting from version 10, PostgreSQL offers table partitioning, which allows splitting tables into parts based on certain criteria, but this is not full sharding.

To implement sharding in PostgreSQL, external solutions are usually used:

• Third-party tools like Citus, which extend PostgreSQL to provide distributed storage and query execution.
• Manual data separation into different databases and routing queries at the application level.

Thus, PostgreSQL itself does not provide full sharding, but with extensions and architectural solutions, distributed data storage can be achieved.