What is the difference between partitioning and sharding?

Partitioning: logical division within a single database server. Data split into partitions on the same machine. Query planner does partition pruning automatically. Transparent to the application. Sharding: physical distribution across multiple database servers (nodes). Each node stores a subset of rows. Requires application awareness (which shard to query) or a middleware layer. Much higher operat