If you have any sigma-algebra $A$ on some finite set $X$ you can partition $X$ and use the disjoint subsets of $X$ to generate $A$. Why cannot you do the same if $X$ was infinite?
I was thinking, it's because you would need uncountably many disjoint subsets. But isn't that how the Borel algebra on $\mathbb{R}$ is generated? There are uncountably many open intervals on $\mathbb{R}$.
So what is so different about other sigma algebras on infinite sets?
It's not all infinite $X$ it doesn't work for. For example, every $\sigma$-algebra on $\mathbb Q$ is generated by a partition -- and likewise for any countable $X$.
The underlying reason is that a $\sigma$-algebra is only supposed to be closed under countable unions or intersections.
This has two effects. First, the argument that produces a partition form an arbitrary $\sigma$-algebra depends on taking intersections that may have as many operands as there are elements in $X$. When we try to apply it to an algebra on $\mathbb R$, we do get disjoint subsets out of it, but those disjoint subsets are not necessarily in the $\sigma$-algebra we started with.
Second, even if the partitions we get are in the $\sigma$-algebra (as is the case for the Borel algebra on $\mathbb R$), they may not generate it. In the case of the Borel algebra, the partitions are just the singletons, but a random Borel set cannot be generated as a countable union of singletons.
(By the way, the Borel algebra doesn't need uncountably many generators -- it is enough to take the open intervals with rational endpoints).